Vespa manufactures and sells a single motor-scooter product. Their production processes are fully automated. There is...

  

Transcribed Image Text:

Vespa manufactures and sells a single motor-scooter product. Their production processes are fully automated. There is no direct labour. All material costs are directly traced to the product. Complete a Production Budget, Income statement, Balance sheet and Cash flow budget for the next 3 months (Jan-Feb). COSTS - PER MONTH Production costs Material Labour (supervision; no direct) Overheads: Depreciation Rent Total Normal capacity utilization Fixed cost per unit Other expenses Sales & Admin Rent PRODUCTION Beginning Inventory Sales forecast Ending inventory Production PROFIT AND LOSS Revenue Cost of Goods Sold Beginning Inventory Add production Less ending inventory Total Cost of Goods Sold Gross Profit Period Expenses Rent Sales & Admin Total Period Expenses. Operating Income Tax (@30%) Net Income Fixed 30,000 15,000 4,000 49,000 500 Fixed 98 120,000 1,000 Jan 0 450 50 500 1,350,000 Variable per unit 1,970 1,000 1,970 Feb 50 Variable Fixed cost for the Sales and Administration department is $120,000 per month. 2% 2% of sales is paid as sales commission. 500 Jan Feb 1,350,000 1,500,000 50 500 Normal production is 500 scooters per month (used for determining the Fixed OH rate). 1,000 Mar 50 350 200 500 Mar 1,050,000 1,500,000 1,050,000 1,000 1,350,000 1,500,000 1,050,000 405,000 945,000 1,500,000 1,050,000 Apr Try again 470 3,000 Sales price BALANCE SHEET Assets Cash: beginning balance Cash: ending balance Accounts Receivable Raw material Inventory Finished Goods Inventory Machinery: at Cost Machinery: Accumulated Depn. Machinery: Net of Depn. Total Assets Liabilities Accounts payable Tax Liability (Asset) Total Liabilities Owners Equity Capital Retained Earnings - Prior Year Retained Earnings - Qtr to date Total Owners Equity CASH FLOWS Revenue Receipts Payments to Suppliers Monthly production fixed costs Period Expenses Tax Paid Net Cash Flow Jan 23,840 197,000 1,800,000 585,000 1,215,000 0 1,092,500 500,000 Jan 1,425,000 701,400 723,600 Feb 1,800,000 1,800,000 1,800,000 1,800,000 0 1,092,500 500,000 Feb 1,425,000 Mar 1,425,000 0 1,092,500 500,000 Mar 405,000 -405,000 50% of revenue collected as cash in the month of sale, with the rest collected in following month. Raw material inventory is kept at a constant level to produce 100 scooters. Finished goods ending target inventory is 10% of the next month's sales forecast. Machinery is depreciated at 10% straight line per year. Accumulated depreciation at 31 December is $570,000. There are no depreciation expenses for the Sales and Administration department. Suppliers are paid in the month following the expenses incurred. The beginning balance for Accounts Receivable in January is $750,000. Accounts Payable beginning balance for Jan. is $701,400 (100% payable in Jan). All paid in the month incurred. All paid in the month incurred. Company tax for the quarter is paid at quarter end. Vespa manufactures and sells a single motor-scooter product. Their production processes are fully automated. There is no direct labour. All material costs are directly traced to the product. Complete a Production Budget, Income statement, Balance sheet and Cash flow budget for the next 3 months (Jan-Feb). COSTS - PER MONTH Production costs Material Labour (supervision; no direct) Overheads: Depreciation Rent Total Normal capacity utilization Fixed cost per unit Other expenses Sales & Admin Rent PRODUCTION Beginning Inventory Sales forecast Ending inventory Production PROFIT AND LOSS Revenue Cost of Goods Sold Beginning Inventory Add production Less ending inventory Total Cost of Goods Sold Gross Profit Period Expenses Rent Sales & Admin Total Period Expenses. Operating Income Tax (@30%) Net Income Fixed 30,000 15,000 4,000 49,000 500 Fixed 98 120,000 1,000 Jan 0 450 50 500 1,350,000 Variable per unit 1,970 1,000 1,970 Feb 50 Variable Fixed cost for the Sales and Administration department is $120,000 per month. 2% 2% of sales is paid as sales commission. 500 Jan Feb 1,350,000 1,500,000 50 500 Normal production is 500 scooters per month (used for determining the Fixed OH rate). 1,000 Mar 50 350 200 500 Mar 1,050,000 1,500,000 1,050,000 1,000 1,350,000 1,500,000 1,050,000 405,000 945,000 1,500,000 1,050,000 Apr Try again 470 3,000 Sales price BALANCE SHEET Assets Cash: beginning balance Cash: ending balance Accounts Receivable Raw material Inventory Finished Goods Inventory Machinery: at Cost Machinery: Accumulated Depn. Machinery: Net of Depn. Total Assets Liabilities Accounts payable Tax Liability (Asset) Total Liabilities Owners Equity Capital Retained Earnings - Prior Year Retained Earnings - Qtr to date Total Owners Equity CASH FLOWS Revenue Receipts Payments to Suppliers Monthly production fixed costs Period Expenses Tax Paid Net Cash Flow Jan 23,840 197,000 1,800,000 585,000 1,215,000 0 1,092,500 500,000 Jan 1,425,000 701,400 723,600 Feb 1,800,000 1,800,000 1,800,000 1,800,000 0 1,092,500 500,000 Feb 1,425,000 Mar 1,425,000 0 1,092,500 500,000 Mar 405,000 -405,000 50% of revenue collected as cash in the month of sale, with the rest collected in following month. Raw material inventory is kept at a constant level to produce 100 scooters. Finished goods ending target inventory is 10% of the next month's sales forecast. Machinery is depreciated at 10% straight line per year. Accumulated depreciation at 31 December is $570,000. There are no depreciation expenses for the Sales and Administration department. Suppliers are paid in the month following the expenses incurred. The beginning balance for Accounts Receivable in January is $750,000. Accounts Payable beginning balance for Jan. is $701,400 (100% payable in Jan). All paid in the month incurred. All paid in the month incurred. Company tax for the quarter is paid at quarter end.

Answer rating: 100% (QA)

complete the production budges Income Boothed Balance shelf and Cath Profit and lov sau ... View the full answer