Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
BEC STUDY GROUP
 CPAnet Forum : BEC STUDY GROUP
Subject Topic: BEC variance question (Topic Closed Topic Closed) Post ReplyPost New Topic
  
Author
Message << Prev Topic | Next Topic >>
mn7861
Newbie
Newbie


Joined: 27 Aug 2009
Online Status: Offline
Posts: 15
Posted: 27 Sep 2009 at 20:25 | IP Logged  

Paul Sunger, the CFO of Amjust, Inc., forecasts sales of
$1 million for April, $1.1 million for May, and $800,000
for June. Historically, fifty percent of sales are cash
and fifty percent are on credit. Seventy percent of
credit purchases are paid within the month in which the
products are sold, while 25% are paid the following
month. Five percent are never collected. Sunger’s
budget assistant has projected cash receipts for June at
$850,000. Sunger expects the cash receipts budget to
show what variance for June?

The answer is 3.8% unfavorable.

I don't understand the explanation that becker provided.
Can someone please explain to me how to tackle this
problem step by step. Thanks!
Back to Top View mn7861's Profile Search for other posts by mn7861
 
kj_nyc
Major Contributor
Major Contributor


Joined: 05 Jun 2009
Location: United States
Online Status: Offline
Posts: 1145
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.

Back to Top View kj_nyc's Profile Search for other posts by kj_nyc Visit kj_nyc's Homepage
 



Sorry, you can NOT post a reply.
This topic is closed.


  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2010 Web Wiz Guide

This page was generated in 0.1094 seconds.

Copyright © 1996-2016 CPAnet/MizWeb Communities All Rights Reserved
Twitter
|Facebook |CPA Exam Club | About | Contact | Newsletter | Advertise & Promote