Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am not sure if I am doing this right but can someone help me on setting up a Pro Forma contribution format income statement
I am not sure if I am doing this right but can someone help me on setting up a Pro Forma contribution format income statement for the upcoming month? for the upcoming month Unit sales will be 67,000, weight shipped is 97,000, and distance shipped 347,000. Thank you.
Month 4 1 2 3 5 6 7 9 10 11 12 Possible Cost Drivers: Distance Shipped (miles) 425,000 562,000 510,900 476,000 420,000 450,000 375,000 550,000 176,000 980,000 784,000 356,000 Weight Shipped (pounds) 58,900 76,000 54,000 65,000 25,000 70,000 72,580 85,000 84,300 90,000 62,000 98,000 Units Sold 35,000 37,500 34,000 29,000 33,000 36,000 59,000 50,000 COGS Advertising CommisionsSalaries Packaging Shipping Costs 38,000 58,000 55,000 56,000 Units 1 0.9 0.9 0.0 1.0 Miles 0.4 0.4 0.2 0.1 0.6 COSTS (all in USD) Pounds 0.0 0.0 0.0 0.1 0.0 Packaging Advertising Commisions Salaries COGS 7.79$ 5.34 $ $ 27.00 $ 3.67 $ 0.02 $ 1.16 $ Variable Cost of Goods 918,000 1,566,000 1,485,000 44.98 945,000 1,012,500 1,026,000 783,000 891,000 972,000 1,593,000 1,512,000 1,350,000 $150,058.18 $58,794.98 $ 124,139.73 $ 43,275.64 $183,034.81 $559,303.34 154,500 Advertising 157,380 156,600 157,490 156,720 155,859 154,850 154,332 154,080 153,480 154,630 154,077 Fixed $ 185,000 186,000 245,000 Selling & Commissions 166,000 182,000 195,000 202,400 283,000 265,000 177,000 273,000 257,000 Admin. Salaries 120,000 120,000 120,000 120,000 130,000 130,000 130,000 Selling Price $ 120,000 120,000 130,000 130,000 130,000 559,303 Packaging 230,000 340,000 200,000 290,000 250,000 260,000 220,000 330,000 210,000 240,000 380,000 350,000 Shipping costs 214,300 230,400 279,950 251,265 203,033 291,100 95,250 234,313 259,171 209,380 223,340 308,860 Unit Sales: 67,000 Weight Shipped: Distance shipped: 97,000 347,000 Pro Forma Contribution Income Statement O OStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started