345 one 4

Problem 1-51 (Algo) Cost Data for Managerial Purposes-Finding Unknowns (LO 1-3) Rigney Manufacturing is a small components maker located in the upper midwest. The company specializes in icraft turbine blades and focused its production around a single family of products. Recently, one of the new members of the company's board of directors suggested the company could increase its profitability by adding a second product line with an increase in the rent the company currently pays of only 10 percent Before the board member could show her analysis, she had to resign, because of a conflict of interest. She left behind the incomplete spreadsheet below apologizing that she had neglected to save the full version. She suggested that you could complete the analysis based on what information was included. Required: Fill in the blank cells(Enter all amounts as positive values.) RIGNEY MANUFACTURING Projected Income Statement For One Quarter Status Quo % Increase Alternative: Single Product Decrease) TWO Products Difference 5 43.490 $ 90.000 224 11,375 2.625 Sales revenue Costs Material Labor Ron Depreciation Utilities Other Total costs Operating profit 47,000 12,500 1,875 15 30 14,375 11.375 1.125 4,500 171,500 $ $ 13.200