Question

In: Accounting

At the beginning for the year 2020, Shanghai Healthy Food Production Company budgeted its cost at...

At the beginning for the year 2020, Shanghai Healthy Food Production Company budgeted its cost at 4 different capacity levels as follows:

Manufacturing Overheads

Capacity Level/Usage (in mh)

10,000

12,000

15,000

20,000

Indirect Materials

30,000

36,000

45,000

60,000

Depreciation

15,000

15,000

15,000

15,000

Supervision

23,000

27,000

33,000

43,000

Energy

48,000

56,000

68,000

88,000

TOTAL

116,000

134,000

161,000

206,000

A) What is the flexible budget formula for the year 2020?

B) What is the Predetermined MOH Rate (Applied MOH Rate) if the budgeted capacity is set at 18,000 mh?

Solutions

Expert Solution

Answer to Part A

Flexible budget formula for 2020 can be derived by analysing the cost nature (Variable, Fixed or Mixed) of all overhead costs given.

Indirect Material here is Variable cost with rate = 30,000 / 10,000 or 36,000 / 12,000 or 45,000 / 15,000 or 60,000 / 20,000 i.e. 3 per mh.

Depreciation is fixed throughout at 15,000 across all capacity levels.

Supervision is a mixed cost here (Fixed + Variable). Variable component can be segregated by following High-Low Method. Variable part = (43,000 - 23,000) / (20,000 - 10,000) = 2 per mh. Thus fixed part is 23,000 - 10,000 *2 = 3000.

Energy is also a mixed cost here. We segregate variable and fix part using High-Low Method. Variable Part = (88,000 - 48,000) / (20,000 - 10,000) = 4 per mh. Fixed part = 48,000 - 10,000*4 = 8,000.

Hence, Flexible Budget Formula for 2020 is :

Indirect Material + Depreciation + Supervision + Energy = (3 * Capacity Level) + 15,000 + (2 * Capacity Level + 3000) + (4 * Capacity Level + 8,000)

Answer to Part B

If the budgeted capacity is set at 18,000 mh, Total Manufacturing overhead (MOH) as per above formula would be : 1,88,000.

Hence, the Predetermined MOH Rate (Applied MOH Rate) = 1,88,000 / 18,000 mh = 10.44 per mh.


Related Solutions

At the beginning of 2016, the Healthy Life Food Company purchased equipment for $42 million to...
At the beginning of 2016, the Healthy Life Food Company purchased equipment for $42 million to be used in the manufacture of a new line of gourmet frozen foods. The equipment was estimated to have a 10-year service life and no residual value. The straight-line depreciation method was used to measure depreciation for 2016 and 2017. Late in 2018, it became apparent that sales of the new frozen food line were significantly below expectations. The company decided to continue production...
The Bright Lamp Company has budgeted its conversion cost for the small lamp production as $85,000...
The Bright Lamp Company has budgeted its conversion cost for the small lamp production as $85,000 for 1,300 production hours. Each unit produced by the cell requires 15 minutes of process time. During the month, 3,800 units are manufactured in the cell. The estimated material cost is $18 per unit. Provide the following journal entries. In your computations, round per unit cost to two decimal places and use rounded amount in subsequent calculations. If required, round your final answers to...
The Task Company is beginning operations in May 2020. They have budgeted May sales of $34,000,...
The Task Company is beginning operations in May 2020. They have budgeted May sales of $34,000, June sales of $40,000, July sales of $42,000, and August sales of $38,000. 10% of each month's sales will represent cash sales; 75% of the balance will be collected in the month following the sale, 17% the second month, 6% the third month, and the balance is bad debts. What is the amount of cash to be collected in the month of August? Select...
1.) If budgeted beginning inventory is $8,800, budgeted ending inventory is $10,000, and budgeted cost of...
1.) If budgeted beginning inventory is $8,800, budgeted ending inventory is $10,000, and budgeted cost of goods sold is $10,760, budgeted purchases should be: $1,960 $760 $11,960 $1,200 $9,560 2.) Use the following information to determine the ending cash balance to be reported on the month ended June 30 cash budget. a. Beginning cash balance on June 1, $94,900. b. Cash receipts from sales, $417,500. c. Budgeted cash disbursements for purchases, $272,500. d. Budgeted cash disbursements for salaries, $95,900. e....
A company rewards its production department employees for meeting budgeted cost levels by giving out bonuses....
A company rewards its production department employees for meeting budgeted cost levels by giving out bonuses. If the department’s costs exceed the budget, employees do not get a bonus. What problems might arise with such a plan?  
The Welding Department of Healthy Company has the following production and manufacturing cost data for February...
The Welding Department of Healthy Company has the following production and manufacturing cost data for February 2017. All materials are added at the beginning of the process. Manufacturing Costs Production Data Beginning work in process Beginning work in process 15,100 units, 1/10 complete     Materials $17,800 Units transferred out 55,000     Conversion costs 15,160 $32,960 Units started 51,200 Materials 211,598 Ending work in process 11,300 units, 1/5 complete Labor 67,900 Overhead 39,476 Prepare a production cost report for the Welding Department for...
The Welding Department of Healthy Company has the following production and manufacturing cost data for February...
The Welding Department of Healthy Company has the following production and manufacturing cost data for February 2017. All materials are added at the beginning of the process. Manufacturing Costs Production Data Beginning work in process Beginning work in process 14,500 units, 1/10 complete Materials $17,500 Units transferred out 55,000 Conversion costs 14,560 $32,060 Units started 50,700 Materials 192,444 Ending work in process 10,200 units, 1/5 complete Labor 67,000 Overhead 67,885 Prepare a production cost report for the Welding Department for...
The Welding Department of Healthy Company has the following production and manufacturing cost data for February...
The Welding Department of Healthy Company has the following production and manufacturing cost data for February 2020. All materials are added at the beginning of the process. Manufacturing Costs Production Data Beginning work in process Beginning work in process 15,000 units, 1/10 complete Materials $18,000 Units transferred out 55,000 Conversion costs 14,175 $32,175 Units started 51,000 Materials 180,000 Ending work in process 11,000 units, 1/5 complete Labor 67,380 Overhead 61,445 Prepare a production cost report for the Welding Department for...
The Welding Department of Healthy Company has the following production and manufacturing cost data for February...
The Welding Department of Healthy Company has the following production and manufacturing cost data for February 2017. All materials are added at the beginning of the process. Manufacturing Costs Production Data Beginning work in process Beginning work in process 15,200 units, 1/10 complete Materials $18,100 Units transferred out 54,700 Conversion costs 14,760 $32,860 Units started 51,000 Materials 220,220 Ending work in process 11,500 units, 1/5 complete Labor 67,500 Overhead 89,880 Prepare a production cost report for the Welding Department for...
The Welding Department of Healthy Company has the following production and manufacturing cost data for February...
The Welding Department of Healthy Company has the following production and manufacturing cost data for February 2020. All materials are added at the beginning of the process. Manufacturing Costs Production Data Beginning work in process Beginning work in process 14,700 units, 1/10 complete     Materials $18,400 Units transferred out 55,300     Conversion costs 14,460 $32,860 Units started 50,600 Materials 229,740 Ending work in process 10,000 units, 1/5 complete Labor 67,500 Overhead 52,695 Prepare a production cost report for the Welding Department for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT