You will need to create a new production schedule for 2022 using level production the sales...

  

Transcribed Image Text:

You will need to create a new production schedule for 2022 using level production the sales forecast given below. Thrusters has a beginning inventory of 5 units and would like an ending inventory of 9 units. Forecast sales in boards are given below. Oct Nov Dec Jan Feb Mar 27 17 12 12 12 17 Apr May Jun Jul Aug Sep 27 57 72 122 82 67 Your schedules and statements should link to the assumptions. I should be able to change values in your assumptions and have the schedules and statements update. The balance sheet for the beginning of the year is given below: Thruster Corporation Balance sheet 30-Sep-21 Assets Liabilities Cash $ 25,000 Accounts Payable $ 26,400 Accounts receivable 30,000 Line of Credit Inventory 3,600 Long term debt 150.000 Current Assets 58,600 total liabilities 176,400 Stock 80,000 Capital Assets 205,000 Retained eamings 7.200 Total Assets $263,600 and equity $263,600 Additional Information The surfboards sell for $1,000 each. 20% of the sales are cash sales and the remainder are accounts receivable paid the following month. The cost per board is $600 these costs are all paid the month following production ⚫ Fixed costs are $144,000 paid in equal amounts each month. You may use these as selling and admin costs in your template Taxes are 20% you may assume the amount calculated on your income statement is paid in April You will need to create a new production schedule for 2022 using level production the sales forecast given below. Thrusters has a beginning inventory of 5 units and would like an ending inventory of 9 units. Forecast sales in boards are given below. Oct Nov Dec Jan Feb Mar 27 17 12 12 12 17 Apr May Jun Jul Aug Sep 27 57 72 122 82 67 Your schedules and statements should link to the assumptions. I should be able to change values in your assumptions and have the schedules and statements update. The balance sheet for the beginning of the year is given below: Thruster Corporation Balance sheet 30-Sep-21 Assets Liabilities Cash $ 25,000 Accounts Payable $ 26,400 Accounts receivable 30,000 Line of Credit Inventory 3,600 Long term debt 150.000 Current Assets 58,600 total liabilities 176,400 Stock 80,000 Capital Assets 205,000 Retained eamings 7.200 Total Assets $263,600 and equity $263,600 Additional Information The surfboards sell for $1,000 each. 20% of the sales are cash sales and the remainder are accounts receivable paid the following month. The cost per board is $600 these costs are all paid the month following production ⚫ Fixed costs are $144,000 paid in equal amounts each month. You may use these as selling and admin costs in your template Taxes are 20% you may assume the amount calculated on your income statement is paid in April

Answer rating: 100% (QA)

Here are the stepbystep calculations without tables Production Schedule October Forecast Sales 27 bo... View the full answer