Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help: I need to provide feedback to the company below based on my calculations I have provided. Can someone please help me with a
Please help:
I need to provide feedback to the company below based on my calculations I have provided. Can someone please help me with a few sentences to get started. Thanks a lot
CASE 929 Master Budget for a Manufacturer [LO3, L04] Garneau Manufacturing Ltd. produces and distributes a special type of chemical compound called Compound WX. The information below about Garneau's operations has been assembled to assist budget preparation. The company is preparing its master budget for the first quarter of 2019. The budget will detail each month's activity and the activity for the quarter in total. The master budget will be based on the following information: a. Selling price is $60 per unit in 2018 and will not change for the first two quarters of 2019. Actual and estimated sales are as follows: Estimated 2019 Actual 2018 November: 10,000 units December: 12,000 units January: 11,000 units February: 10,000 units March: 13,000 units April: 11,000 units May: 11,000 units b. The company produces enough units each month to meet that month's sales plus a desired inven- tory level equal to 20% of next month's estimated sales. Finished Goods inventory at the end of 2018 consisted of 2,200 units at a variable cost of $33 each. The company purchases enough raw materials each month for the current month's production re- quirement and 25% of next month's production requirements. Each unit of product requires 5 kilo- grams of raw material at $0.60 per kilogram. There were 13,500 kilograms of raw materials in inventory at the end of 2018. Garneau pays 40% of raw material purchases in the month of purchase and the remaining 60% in the following month. d. Each unit of finished product requires 1.25 labour-hours. The average wage rate is $16 per hour. Variable manufacturing overhead is 50% of the direct labour cost. f. Credit sales are 60% of total sales. The company collects 50% of the credit sales during the first month following the month of sale and 50% during the second month. Fixed overhead costs (per month) are as follows: e. 8. Factory supervisor's salary Factory insurance.. Factory rent Depreciation of factory equipment $75,000 1,400 8,000 1,200 h. Total fixed selling and administrative expenses are as follows: Advertising.. Depreciation Insurance $ 300 9,000 250 1 Sales Budget: January February March Sales in units (storage systems) 11,000 10,000 13,000 Unit sales price 60 60 60 Sales in dollars $660,000 $600,000 $780,000 Production Budget: January February March Sales in units (storage systems) 11,000 10,000 13,000 2,000 2,600 2,200 Add: Desired ending finished goods inventory 13,000 12,600 15,200 Finished goods requirements Less: Beginning finished goods inventory 2,200 2,000 2,600 Production requirements 10,800 10,600 12,600 Raw materials purchases budget: January February March Units of production required 10,800 10,600 12,600 Units of raw materials required (5 kg per unit) 54,000 53,000 63,000 Add Desired ending inventory 13,250 15,750 13,750 Total requirements 67,250 68,750 76,750 13,500 Less Beginning inventory 13,250 15,750 Raw materials to purchase: In Units (kilograms) 53,750 55,500 61,000 In Dollars (9.60 per kilogram) $ 32,250 $33,300 $36,600 Direct labour and Overhead budget: January February March Units of production required 10,800 10,600 12,600 13,500 13,250 15,750 Direct labour hours required (1.25 per unit) Direct labour cost ($16/hr) $216,000 $212,000 $252,000 Manufacturing overhead: Variable (50% of DL) $108,000 $106,000 $126,000 Fixed* 85,600 85,600 85,600 Total manufacturing overhead 193,600 191,600 211,600 Total cost of direct labour and manufacturing overhead $409,600 $403,600 $463,600 Selling & administrative budget: January February March Sales in units 11,000 10,000 13,000 Variable: Shipping (54 per unit) $ 44,000 $ 40,000 $ 52,000 Sales commissions (10% of sales) 66,000 60,000 78,000 Total 110,000 100,000 130,000 Fixed** 34,100 34,100 34,100 Total $144,100 $134,100 $164,100 Cash budget: January February March Cash balance, beginning $ 80,000 $ 30,000 $ 30,000 Operating cash receipts: Cash sales 264,000 240,000 312,000 From previous month's sales 216,000 198,000 180,000 From 2nd previous month's sales 180,000 216,000 198,000 Total 660,000 654,000 690,000 740,000 684,000 720,000 Budgeted Balance Sheet March 31, 2016 Assets Cash $ 30,000 Accounts receivable* 648,000 Inventory: Raw materials** $ 8,250 Finished goods*** 72,600 80,850 Property and equipment, net**** ($1,300,000 - $148,600). 1,151,400 Total assets.. $1,910,250 Liabilities and Shareholders' Equity Accounts payable, purchases (60% x $36,600............ $ 21,960 Bank loan***** 36,264 6% Long-term Note payable.. 900,000 Common shares.. 735,000 Retained earnings (see below). 217,026 Total liabilities and Shareholders' equity.. $1,910,250 Retained earnings at March 31: Balance, January 1. $13,700 Add net income****** 203,326 Total 217,026 Less dividends declared... Q Balance, March 31. $217,026Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started