Question: I know this is over the limit for how many questions can be answered. I can submit blank questions to compensate. a. Unit selling price

I know this is over the limit for how many questions can be answered. I can submit blank questions to compensate.

I know this is over the limit for how many questions canbe answered. I can submit blank questions to compensate. a. Unit sellingprice $ 63.00 The 2020 unit prices will not change for thefirst two quarters of 2021 Estimated sales in units) are as follows:Actual 2020 November 9,800 December 10,700 Estimated 2021 January 10,700 February 10,200March 13,000 April 9,800 May 12,400 b. The company produced enough unitseach month to meet the month's sales plus a desired inventory level

a. Unit selling price $ 63.00 The 2020 unit prices will not change for the first two quarters of 2021 Estimated sales in units) are as follows: Actual 2020 November 9,800 December 10,700 Estimated 2021 January 10,700 February 10,200 March 13,000 April 9,800 May 12,400 b. The company produced enough units each month to meet the month's sales plus a desired inventory level that is based on the following months estimated sales. Desired finished goods inventory level 20% Finished goods inventory at the end of 2020 Units Price per unit 2,140 33.00 $ c. The company purchases enough raw materials each month for the current month's production requirement and a percentage[below of what will be needed in the following month's production. Desired raw materials inventory 20% Each unit requires: RM Unit cost: 5.00 kgs 0.60 $ Raw Materials inventory at the end of 2020 Units 10,600 kgs Raw materials purchase policies Amount paid in current month Amount paid in following month 40% 60% d. Direct labour hours required for one unit of production Direct labour hours required 1.25 hours Direct labour cost per hour $ 16.00 e. Variable manufacturing overhead is allocated on the basis of direct labour cost. Predetermined Overhead Rate 50% f. The company has the following cash/credit sales policy Proportion of cash sales 10% Proportion of credit sales collected in following month 45% Proportion of credit sales collected 2 months later 55% g. Fixed overhead costs (per month) Factory supervisor salary Factory insurance Factory rent Depreciation of factory equipment $ $ S $ 75,400 1,350 7,550 1,150 ht. Total monthly fixed selling and administrative expenses Advertising $ 1,200 Depreciation $ 1,150 Insurance S 1,150 Salaries $ 1,250 Other S 1,150 i. Variable selling and administrative expenses Shipping costs Commissions $ 3.90 per unit 8% of sales j. The company will acquire the following assets at the end of January Furniture and equipment for the sales office $ 515,000 Monthly depreciation expense $ 10,300 "The acquisition of this furniture and equipment was contracted a year earlier and was in a contractual obligation to proceed with the purchase k. The balance sheet as at December 31, 2020 S 75,000 $ 912,303 Assets Cash Accounts receivable Inventory: Raw materials Finished goods Plant and equipment Less: Accumulated Depreciation Total Assets $ 76,980 $ 6,360 $ 70,620 $ 965,000 $ 96,500 $ 868,500 $ 1,932,783 Sales Budat January February March April Sales in units Unit sales price Sales in Dollars b. Production Budget January February March April Sales in units Add: Desired ending finished goods Finished goods requirements Less: Beginning finished goods Production requirements Raw materials purchases budget January February March April Units of production required Units of raw materials required per unit Total units of raw materials required Add: Desired ending inventory Total requirements Less: Beginning inventory Raw materials to purchase Cost per unit of raw materials Raw materials purchase cost d. Direct labour and Overhead budget January February March Units of production required Direct labour hours required per unit Total direct labour hours required Direct labour cost per unit Total direct labour cost Manufacturing overhead: Variable Fixed Total manufacturing overhead Total cost of direct labour and manufacturing overhead e. Selling and administrative budget January February March Sales in units Variable: Shipping per unit Total shipping Sales commissions % of sales Total sales commissions Fixed Total 1. Cash budget January February March Cash balance, beginning Cash receipts: Cash sales From previous month sales From 2nd previous month sales Total Operating cash payments: Raw materials purchases Current month Previous month Direct labour Variable overhead Fixed overhead Variable selling and admin Fixed selling and admin Purchase of equipment Total Net Cash inflows outflows] Interest on notes payable Excess(deficiency of cash available Borrowing Repayment Interest on bank loan Ending balance Budgeted Contribution Format Income Statement For January, February and March 2021 January February March Calculation of Unit Variable Cost Sales revenue Less variable expenses: Variable cost of good sold Selling and administrative Total variable expenses Contribution margin Less fixed expenses: Manufacturing overhead Selling and administrative Totalfixed expenses Operating income loss) Less interest expense Net income loss) Garden Manufacturing Budgeted Balance Sheet 31st March 2021 Assets Cash Account receivable Inventory Raw materials Finished goods Property plant and equipment (net) Total assets Liabilities and Shareholders' Equity Accounts payable Bank loan 6% long-term notes payable Common shares Retained earnings Total liabilities and shareholders' equity Retained earnings at March 31: Balance, January 1 Add net incomelloss Garden Manufacturing Budgeted Absoprtion Costing Income Statement For January, February and March 2021 January February March Calculation of Unit Variable Cost DM DL VOH Sales revenue Less: Cost of goods sold Gross Margin Less selling and administrative expenses Operating income (loss) Less interest expense Net income (loss) FMOH per unit calculation FMOH Cost Units Produced Variable to absorption costing reconciliation Beginning finished goods Ending finished goods Change x Unit FMOH Absorption net income Variable costing net income Liabilities and Equity Accounts payable 6% long-term notes payable Common shares Retained earnings Total liabilities and shareholders' equity S 25,000 $ 880,000 $ 710,000 $317,783 $ 1,932,783 L Interest rate on debt monthly, simple interes Minimum cash balance 0.50% $30,000 Additional information * All cash payments except purchases of raw materials are made monthly as incurred. * All borrowings occur at the beginning of each month and all repayments occur at the end of the month. Borrowings and repayments may occur in any amount * All interest on borrowed funds is paid at the end of each month at a rate of 0.5% per month * A minimum cash balance of $30,000 is required at the end of each month. * All accounts payable is from the purchase of raw materials, all other payments are made in cash

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!