Question

The following information is available for year 1 for Pepper Products $2.850.000 $ 168.000 142.100 327.600 899,000 Sales revenus 200,000 units) Manufacturing costs Materials Variable cash costs Foxed cash coete Depreciation foed) Marketing and administrative coats Marketing (variable, cashi Marketing depreciation Administrative (beo, cash) Administrative depreciation Total costs Operating profits 122.100 149.600 509,200 74,800 $2,793,000 $ 57.000 All depreciation charges are fixed and are expected to remain the same for year 2. Seles volume is expected to tell by 5 percent, but prices are expected to rise by 15 percent. Material costs per unit are expected to increase by 12 percent. Other unit variable manufacturing costs are expected to decrease by 10 percent per unit. Fixed cash casts are expected to increase by 4 percent. Variable marketing costs will change with unit volume. Administrative cash costs are expected to increase by 5 percent. Inventories are kept at zero. Pepper Products operates on a cash basis. Reguired: Prepare a budgeted income statement for year 2. (Do not round intermediate calculations.) PEPPER PRODUCTS Budgeted Income Statement For Year 2 Manufacturing costs: Tolal manufacturing costs Marketing and administrative costs Total marketing and administrative posts Total costs

Answer 1

Please find below table showing calculations of Year 2 based on Year 1 and corresponding increase or decrease to arrive at Year 2.

Please input figures as per highlighted columns only in your excel for Year 2

Pepper Products Budgeted Income Statement For Year 1 Price per unit (sales(or) Unit (as cost/ Total (as given) total unit) given) 200000 14.25 2,850,000.00 For Year 2 Price per % increase / Unit (5% unit % increase / less as (sales(or) in price per (decrease) compared cost / total unit in Total ($) to year 1 unit) 15% 190000 16.39 Ref Description Sales Total ($) 3,113,625.00 200000 200000 0.84 0.71 12% -10% 190000 190000 0.94 0.64 168,000.00 142,400.00 327,600.00 999,000.00 1,637,000.00 4% 0% 178,752.00 121,752.00 340,704.00 999,000.00 1,640,208.00 Manufacturing Cost: Materials Variable Cash Cost Fixed Cash Cost Depreciation (fixed) Total Manufacturing cost Marketing & Administrative Cost Marketing (Variable Cost) Marketing Depreciation Administrative (fixed, cash) Administrative Depreciation Total Marketing & Administrative Cost C 200000 2.11 0% 1900002 .11 0% 422,400.00 149,600.00 509,200.00 74,800.00 1,156,000.00 401,280.00 149,600.00 534,660.00 74,800.00 1,160,340.00 Total Cost D=B+C 2,793,000.00 2,800,548.00 Operating Profit (Sales - Cost) |A-D 57,000.00 | 313,077.00