Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribed

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 O

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Agile Auditing Fundamentals And Applications

Authors: Raven Catlin, Danny M Goldberg, Ceciliana Watkins

1st Edition

1119693462, 9781119693468

More Books

Students also viewed these Accounting questions

Question

explain the payment rule surrounding code K 0 3 9 .

Answered: 1 week ago

Question

What is job enlargement ?

Answered: 1 week ago

Question

what is the most common cause of preterm birth in twin pregnancies?

Answered: 1 week ago

Question

Which diagnostic test is most commonly used to confirm PROM?

Answered: 1 week ago

Question

What is the hallmark clinical feature of a molar pregnancy?

Answered: 1 week ago