vz plans the follow ing for the upcoming quarter Aug 12,800,000 00 5 15, 360,000 L , 16,000,000 oo i The company projects cash collections a payments as follows 40%,colected current month, 60% 35% of sales next month Cost of Goods Sold Vanable Cost 2.560 000 per month inci $200 000 depreciation expense Operating Expense Vanable Sell and Admn 16%of sales Fixed Selling and Admin expense 384,000 per month indl $50,000 depreciation variable costs are pad 70% in month incurred and 30% the folowing month Foxed costs are paid monthly as they are incurred in August an insurance payment of /R on July 1 and are expected to be collected in July AP on July 1 is expected to be paid in July Cash on hand on July 1. Minimum cash on hand is $900,000 and the company borrows and pays 1% interes! per month 3.200,000 00 1,920,000 00 640,000 Prepare a cash budget for July -Sept based on the above Problem2 Upton Mig has the following plans for the upcoming fiscal year: Sales (1 million unts) Cost of Goods Sold 16,640 000 10,816.000 3,494 400 Currently the fixed expense in the manufacturing costs and the fixed expense in the operating costs is What is breakeven in sales dollars and units under this current plan 800 698 880 00 What must the company sell in order to make a 52,500,000 pre-tax profit? The companyconsidering having some of the machining done outside which will reduce fxed costs (in cost of goods sold) by $2,900,000 and increase variable costs by $1.00 per unst if the company plans on selaing a miion units, should it make the Explain why or why not Problem Downton Mig manufactures lighting flxtures and has nine divisions, each which is an investment center. Operating data for the commercial division is -1 378,000 favorable 2,600,000 3,780,000 1,008,000 1890,000 Variable Cos 20,160 anable Seling Exp Controlable Fixed cos Controllable Fixes Seling Exp Average Operating assets for the division were $18,000,000 as budgeted Prepare a responsibility report Comment on the performance Compute ROI Problem4 Plan Dir Material 60,000 units Actual 58.200 units 1 11a 12 40,363600 003, 41,400,000 .00 S 40 986 000 00 Dir Labor 180,000.00 hrs 169,200 00 hrs 2.595.600 00 $2,520,000.00 1 Var Ohead Fixed Ohead 600,000.00 300,000 0o 000.00 300,000 00 6, Prepare vaniance analysis for labor, material and overhead both price vz plans the follow ing for the upcoming quarter Aug 12,800,000 00 5 15, 360,000 L , 16,000,000 oo i The company projects cash collections a payments as follows 40%,colected current month, 60% 35% of sales next month Cost of Goods Sold Vanable Cost 2.560 000 per month inci $200 000 depreciation expense Operating Expense Vanable Sell and Admn 16%of sales Fixed Selling and Admin expense 384,000 per month indl $50,000 depreciation variable costs are pad 70% in month incurred and 30% the folowing month Foxed costs are paid monthly as they are incurred in August an insurance payment of /R on July 1 and are expected to be collected in July AP on July 1 is expected to be paid in July Cash on hand on July 1. Minimum cash on hand is $900,000 and the company borrows and pays 1% interes! per month 3.200,000 00 1,920,000 00 640,000 Prepare a cash budget for July -Sept based on the above Problem2 Upton Mig has the following plans for the upcoming fiscal year: Sales (1 million unts) Cost of Goods Sold 16,640 000 10,816.000 3,494 400 Currently the fixed expense in the manufacturing costs and the fixed expense in the operating costs is What is breakeven in sales dollars and units under this current plan 800 698 880 00 What must the company sell in order to make a 52,500,000 pre-tax profit? The companyconsidering having some of the machining done outside which will reduce fxed costs (in cost of goods sold) by $2,900,000 and increase variable costs by $1.00 per unst if the company plans on selaing a miion units, should it make the Explain why or why not Problem Downton Mig manufactures lighting flxtures and has nine divisions, each which is an investment center. Operating data for the commercial division is -1 378,000 favorable 2,600,000 3,780,000 1,008,000 1890,000 Variable Cos 20,160 anable Seling Exp Controlable Fixed cos Controllable Fixes Seling Exp Average Operating assets for the division were $18,000,000 as budgeted Prepare a responsibility report Comment on the performance Compute ROI Problem4 Plan Dir Material 60,000 units Actual 58.200 units 1 11a 12 40,363600 003, 41,400,000 .00 S 40 986 000 00 Dir Labor 180,000.00 hrs 169,200 00 hrs 2.595.600 00 $2,520,000.00 1 Var Ohead Fixed Ohead 600,000.00 300,000 0o 000.00 300,000 00 6, Prepare vaniance analysis for labor, material and overhead both price