HELPPPP PLEASE SOLVE. ALL MY BOXES ARE WRONG :( So ignore the numbers I have already in those boxes except for the new price = 21, which is correct. I am in need for serious help and this is my last option.

I. Master Budget Pedro's Pizza makes frozen pizza dough. The company just finished its first year of operation (12 months, Jan-Dec). The following is its traditional income statement and Balance Sheet Sales (15,000 units) CGS Gross Profit $ 300,000 180,000 $ 120,000 $30,000 30,000 Sales Commissions Depreciation expense Net Income 6.000 $54,000 $3,000 5,000 Credit Line 7,000 Cash AR Inventory - Raw Mat Inventory -Finished Goods Equipment Acc Depreciation $5,000 AP Common Stock 12,000 60,000 Retained Earn 54,000 3,000 6.000) $76,000 Total L &Eq $76.000 Total Assets VCP wants to prepare a cash budget for the first 3 months of the next year Use the following estimates: The quantity sold is projected to increase 496 for the year. 5% Sales are spread evenly throughout the year. on a FIFO basis. Price will increase - CGS should be calculated -25% of sales is collected in the month of sale; the remainder is collected the next month. Inventory: Last year's Finished Goods and Cost of Goods Sold had a constant cost per unit. All raw materials is purchased on credit (S1.50 per lb) and is the same price as last year. Each product requires 2.5 lbs). Ending inventory for both should be 40% of next month's activity (activity is constant). o o o o Beginning and ending WIP is zero 20% of purchases are paid in the month of purchase, 80% in the following. All other expenses are paid with cash. Direct Labor is 0.2 hours per product at $30 per hour. Variable Overhead is $2.25 per product. Fixed Overhead is zero. The credit line is used for cash shortfalls. Excess cash will pay down this line. Interest is 1% per month of last month's balance. Projections are to buy $6000 of new equipment at the end of January. Equipment is depreciated straight-lHine to zero salvage over 5 years. All of this is used in administration. Sales commission rate will remain the same. Salaries will increase by VCP wants to maintain a minimum cash balance of at least $5,000. Excess to repay credit line. - - I. Master Budget Pedro's Pizza makes frozen pizza dough. The company just finished its first year of operation (12 months, Jan-Dec). The following is its traditional income statement and Balance Sheet Sales (15,000 units) CGS Gross Profit $ 300,000 180,000 $ 120,000 $30,000 30,000 Sales Commissions Depreciation expense Net Income 6.000 $54,000 $3,000 5,000 Credit Line 7,000 Cash AR Inventory - Raw Mat Inventory -Finished Goods Equipment Acc Depreciation $5,000 AP Common Stock 12,000 60,000 Retained Earn 54,000 3,000 6.000) $76,000 Total L &Eq $76.000 Total Assets VCP wants to prepare a cash budget for the first 3 months of the next year Use the following estimates: The quantity sold is projected to increase 496 for the year. 5% Sales are spread evenly throughout the year. on a FIFO basis. Price will increase - CGS should be calculated -25% of sales is collected in the month of sale; the remainder is collected the next month. Inventory: Last year's Finished Goods and Cost of Goods Sold had a constant cost per unit. All raw materials is purchased on credit (S1.50 per lb) and is the same price as last year. Each product requires 2.5 lbs). Ending inventory for both should be 40% of next month's activity (activity is constant). o o o o Beginning and ending WIP is zero 20% of purchases are paid in the month of purchase, 80% in the following. All other expenses are paid with cash. Direct Labor is 0.2 hours per product at $30 per hour. Variable Overhead is $2.25 per product. Fixed Overhead is zero. The credit line is used for cash shortfalls. Excess cash will pay down this line. Interest is 1% per month of last month's balance. Projections are to buy $6000 of new equipment at the end of January. Equipment is depreciated straight-lHine to zero salvage over 5 years. All of this is used in administration. Sales commission rate will remain the same. Salaries will increase by VCP wants to maintain a minimum cash balance of at least $5,000. Excess to repay credit line