Posted: 27 Sep 2009 at 22:03 | IP Logged
|
|
|
budgeted june cash receipts based on historical: June cash sales .5*800k = $400,000 Total June credit sales are the other 50% (400k), 70% of that is collected: .7*400k = $280,000 25% of May credit sales are also collected in June (remember that 50% of total sales are on credit): 1.1M*.5*.25 = $137,500 Total budgeted June cash receipts = 400,000+280,000+137,500 = $817,500
$850,000 projected as stated above Difference: 850,000-817,500 = $32,500. Budget is less than projected, which would make budget unfavorable relative to projected because budgeted is less than projected. Although, normally we're asked actual compared to budgeted, so this is a strange problem.
As for %, if they want % of projected, which they apparently seem to, it's 32500/850000 = 3.8235% unfavorable, but % of budgeted, which is what problems usually ask for but I guess they are not asking for it in this problem, would be 32500/817500 = 3.975% and would be favorable
Does Becker include the $ variance as well? Does it agree with the $32,500 I calculated above? I think the wording is a bit confusing in this problem.
|