Bloom Corp. produces one product that sells at $20 per unit and sells best on Valentine's...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Bloom Corp. produces one product that sells at $20 per unit and sells best on Valentine's Day and Mother's Day. As a result peak sales occur in February and May of each year. Budgeted sales in units for the first six months of the coming year are: Month Units January 12,000 February 32,000 March 18,000 34,000 30,000 15,000 April May June 25% of all sales are cash sales and the rest are on account. Past experience shows that the company collects 25% of a month's credit sales in the month of sale. Another 65% of credit sales is collected in the month following sale, and the remaining 10% of credit sales is collected in the second month following sale. Bad debts are negligible and can be ignored. To ensure that sales volumes can be met, the company requires that ending inventory for a particular month reflect 15% of next month's sales. Assume June 30 closing inventory will be 1,500 units. Required: a) Prepare a sales budget in dollars and a schedule of cash collections from sales, by month and in total, for the second quarter (10 marks). b) If the company prepares a budgeted balance sheet as of June 30, compute the accounts receivable as of that date (5 marks). Prepare a production budget by month and in total for the first quarter (5 marks). CBH Associates is reeling from a decline in profits because of competition. For its most recent year end, its controller has prepared following variance analysis and concluded that the company has done very well controlling its costs: Budgeted Actual Variance Variable Costs: Professional labour $ 1,000,000 $ 50,000 940,000 $ 40,000.00 60,000 $10,000 F $10,000 Travel Supplies 100,000 90,000.00 Fixed Costs: Professional labour 400,000 405,000 -$5,000 U -$15,000 U $2,000 F Facilities Csots 250,000 265,000 Insurance 80,000 78,000 Total Costs $ 1,880,000 $ 1,818,000 $ 62,000 For the year CBH Associates projected that it would generate $2,000,000 of revenues; it actually generated $1,800,000. The company has consulted with you for help in understanding what is happening. You decide to address the following items. 1 Comment on the usefulness of the report above in performing cost control evaluation. (3 marks) 2 Prepare an alternative performance report to enable more meaningful cost control evaluation (use flexible budgeting and identify volume and price variances). (7 marks) The CFO of Carrie Electric Auto, Mary Scofield is debating an investment. The investment is projected to earn $100,000 annually and will require the company to acquire $600,000 in assets. The following chart summarizes Mary's decision: Before After Investment Investment Sales $ 3,500,000 $ 4,100,000 Operating Income Average Operating Assets 600,000 $ 700,000 3,000,000 3,600,000 Required: a.) Assume Mary is evaluated based on growth in the company's ROI. Compute the Return on Investment including the margin and turnover components for the company before and after the investment. Would you recommend Mary make the investment? Why (refer to margin and turnover in your answer)? (5 marks) b.) Assume Mary is evaluated based on growth in the company's residual income. The company's required rate of return is 15%. Compute the company's residual income before and after the investment. Would you recommend Mary make the investment? (3 marks) c.) Give at least one advantage and one disadvantage of using measures like ROI and residual income to evaluate company performance. (2 marks) Bloom Corp. produces one product that sells at $20 per unit and sells best on Valentine's Day and Mother's Day. As a result peak sales occur in February and May of each year. Budgeted sales in units for the first six months of the coming year are: Month Units January 12,000 February 32,000 March 18,000 34,000 30,000 15,000 April May June 25% of all sales are cash sales and the rest are on account. Past experience shows that the company collects 25% of a month's credit sales in the month of sale. Another 65% of credit sales is collected in the month following sale, and the remaining 10% of credit sales is collected in the second month following sale. Bad debts are negligible and can be ignored. To ensure that sales volumes can be met, the company requires that ending inventory for a particular month reflect 15% of next month's sales. Assume June 30 closing inventory will be 1,500 units. Required: a) Prepare a sales budget in dollars and a schedule of cash collections from sales, by month and in total, for the second quarter (10 marks). b) If the company prepares a budgeted balance sheet as of June 30, compute the accounts receivable as of that date (5 marks). Prepare a production budget by month and in total for the first quarter (5 marks). CBH Associates is reeling from a decline in profits because of competition. For its most recent year end, its controller has prepared following variance analysis and concluded that the company has done very well controlling its costs: Budgeted Actual Variance Variable Costs: Professional labour $ 1,000,000 $ 50,000 940,000 $ 40,000.00 60,000 $10,000 F $10,000 Travel Supplies 100,000 90,000.00 Fixed Costs: Professional labour 400,000 405,000 -$5,000 U -$15,000 U $2,000 F Facilities Csots 250,000 265,000 Insurance 80,000 78,000 Total Costs $ 1,880,000 $ 1,818,000 $ 62,000 For the year CBH Associates projected that it would generate $2,000,000 of revenues; it actually generated $1,800,000. The company has consulted with you for help in understanding what is happening. You decide to address the following items. 1 Comment on the usefulness of the report above in performing cost control evaluation. (3 marks) 2 Prepare an alternative performance report to enable more meaningful cost control evaluation (use flexible budgeting and identify volume and price variances). (7 marks) The CFO of Carrie Electric Auto, Mary Scofield is debating an investment. The investment is projected to earn $100,000 annually and will require the company to acquire $600,000 in assets. The following chart summarizes Mary's decision: Before After Investment Investment Sales $ 3,500,000 $ 4,100,000 Operating Income Average Operating Assets 600,000 $ 700,000 3,000,000 3,600,000 Required: a.) Assume Mary is evaluated based on growth in the company's ROI. Compute the Return on Investment including the margin and turnover components for the company before and after the investment. Would you recommend Mary make the investment? Why (refer to margin and turnover in your answer)? (5 marks) b.) Assume Mary is evaluated based on growth in the company's residual income. The company's required rate of return is 15%. Compute the company's residual income before and after the investment. Would you recommend Mary make the investment? (3 marks) c.) Give at least one advantage and one disadvantage of using measures like ROI and residual income to evaluate company performance. (2 marks)
Expert Answer:
Answer rating: 100% (QA)
Step 1 In the above question we have asked to prepare sales budget cash collection from sales produc... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Budgeted sales of The Music Shop for the first six months of 2010 are as follows: Beginning inventory for 2010 is 40,000 units. The budgeted inventory at the end of a month is 40 percent of units to...
-
3. Suppose that o: G G' is a group homomorphism and a Ker(o). Show that for any gG, gag Ker(p).
-
Herbert was employed for the first six months of 2014 and earned $90,000 in salary. During the next six months, he collected $8,800 of unemployment compensation, borrowed $12,000 (using his personal...
-
Differentiate between formal and behavioral roles, and describe how behavioral roles emerge during group interaction.
-
What is the Internet Crime Computer Center and what does it do?
-
Ryser Company was organized on May 1. On that date the company purchased 35,000 plastic emblems, each with a peel-off adhesive backing. The front of the emblems contained the companys name,...
-
Ashton, Inc., which closes its books on December 31, is authorized to issue \(\$ 800,000\) of nine percent, 20-year bonds dated May 1 , with interest payments on November 1 and May 1. Required...
-
Halles Berry Farm establishes a $400 petty cash fund on September 4 to pay for minor cash expenditures. The fund is replenished at the end of each month. At the end of September, the fund contains...
-
Riverside Fashions is typical of many clothing manufacturers. It operates with a lot of inventory and pays its workers according to a piece rate system to assure high productivity. In class we will...
-
Presented below is financial information related to the 2020 operations of Sea Legs Cruise Company. Maintenance and repairs expense ............$ 95,000 Utilities expense...
-
Assume that you are a Railway Electrification Engineer working with a multinational company that offers professional services and consultation for railway electrification system. Your function...
-
On March 15, 2020, a woman (Victim)is shot and killed in the elevator of a posh high-rise apartment in Dallas, TX at 8:15am. Police, through the course of their investigation, discover that Victim...
-
The role of capital markets is paramount in the global economy, serving as the nexus where entities raise funds by issuing securities and investors allocate capital to various investment...
-
In a reverted epicyclic train (Fig. 15.39), the arm A carries two wheels B and C and a compound wheel D-E. The wheel B gears with wheel E and the wheel C gears with wheel D. The number of teeth on...
-
Shorty is worried that his health may soon deteriorate to the point wnere ne will no longer be able to take care of his own finances. One way he could ease his mind would be to: name an executor to...
-
Explain McCausland's interpretation of Matthew's use of Scripture. what evidence does he offer to support his interpretation? 2. Select any one of the cases of Matthew's use of Scripture presented by...
-
Now that we know the crude rates for LA and FL (562.78 per 100,000 population and 184.53 per 100,000 population), and the adjusted rate using the combined population as the standard (358.76 deaths...
-
In Exercises 105108, evaluate each expression without using a calculator. log(ln e)
-
A countercurrent leaching system is recovering oil from soybeans with five stages. On a volumetric basis, liquid flow rate/solids flow rate \(=1.36\). Recovery of oil in the solvent is \(97.5 \%\)....
-
Barium sulfide is produced by reacting barium sulfate ore with coal. The result is barium black ash, which is \(\mathrm{BaS}\) plus insoluble solids. Since \(\mathrm{BaS}\) is soluble in water, it...
-
Batch leaching is similar to batch extraction, and the equations developed in Section 13.6 can be adapted when the solution is dilute or there is an insoluble solid matrix. We have \(12.5...
Study smarter with the SolutionInn App