+ Whitman inc. makes a complex product. Recently, the general manager of the company expressed concern about...

+  

Transcribed Image Text:

Whitman inc. makes a complex product. Recently, the general manager of the company expressed concern about a lack of coordination between purchasing and production staff. He believes a monthly budgeting system would be preferable to the current system. The general manager has prepared forecast information for the third quarter of the current year as a test before implementing the budgeting system for an entire financial period. With the CEO requesting data that could be used to prepare the new budget, Whitman's comptroller gathered the following data Sales As of June 30, sales were 20,000 units in the first six months of the current year. Actual unit sales for the months of May and June, and forecast unit sales for the following five months are detailed as follows: May (actual sales) 3.000 3 000 4 000 June (actual sales) July (planned sales) August (sales planned) September (sales planned) October (planned sales) 5 000 6 000 6 500 November (sales planned) 7000 Whitman expects to sell 55,000 units in the year ending December 31. Raw materials The data concerning the raw materials used in the manufacture of the units are shown in the table below. The monthly stock of raw materials at the end must meet 40% of the production needs of the following month. Raw materials Unit cost Stock level at June 30 Raw material units per unit or finished component 3g Number 101 $3,00 14 000 g Direct labor Each unit must go through three stages. The data concerning direct labor are as follows: Stage Hours of direct labor per unit/ Cost per hour of direct labor component Formatting 1.00 14 $ Assembly 2,00 9 $ Finishing 0,20 11 $ Whitman inc. makes a complex product. Recently, the general manager of the company expressed concern about a lack of coordination between purchasing and production staff. He believes a monthly budgeting system would be preferable to the current system. The general manager has prepared forecast information for the third quarter of the current year as a test before implementing the budgeting system for an entire financial period. With the CEO requesting data that could be used to prepare the new budget, Whitman's comptroller gathered the following data Sales As of June 30, sales were 20,000 units in the first six months of the current year. Actual unit sales for the months of May and June, and forecast unit sales for the following five months are detailed as follows: May (actual sales) 3.000 3 000 4 000 June (actual sales) July (planned sales) August (sales planned) September (sales planned) October (planned sales) 5 000 6 000 6 500 November (sales planned) 7000 Whitman expects to sell 55,000 units in the year ending December 31. Raw materials The data concerning the raw materials used in the manufacture of the units are shown in the table below. The monthly stock of raw materials at the end must meet 40% of the production needs of the following month. Raw materials Unit cost Stock level at June 30 Raw material units per unit or finished component 3g Number 101 $3,00 14 000 g Direct labor Each unit must go through three stages. The data concerning direct labor are as follows: Stage Hours of direct labor per unit/ Cost per hour of direct labor component Formatting 1.00 14 $ Assembly 2,00 9 $ Finishing 0,20 11 $

Answer rating: 100% (QA)

1 Production Budget Unit Sales Add Desired endinmg units Total Units Needs Less Beginning Units Unit... View the full answer