Cost Data for Managerial Purposes Assignment

(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 aircraft 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 45,556 Sales revenue Costs Material $ 95,000 22% 11,440 2,640 50,000 13,000 1,950 Labor Rent Depreciation Utilities Other Total costs Operating profit N 15 % 30 % N 14,950 11,440 1,150 4,600 180,200 $ $ 13,300.