Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I do this income statement from these numbers? The chicken or the egg-Financials (Template) V1 Q-Search Sheet Home Insert Page Layout Formulas Data

image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribed

How do I do this income statement from these numbers?

The chicken or the egg-Financials (Template) V1 Q-Search Sheet Home Insert Page Layout Formulas Data Review View Conditional Formatting Format as Table Cell Styles 10 , ?-?? ?. % Times New R Paste BIU A AlignmentNumber Cells Editing Case Configuration.: 10 11 12 13 14 15 16 17 18 Pounds per Case Bags per Case 15 Expected pounds per case Expected number of bags per case 12 Sales Price/Coupon Costs/Commission: Percent/Per Bag Bags/Case Per Case Sales Price to Retailers (S per bag) Coupon Costs (S per bag) Commission (percent) 3.00 0.20 6.00% 12 S 12 $ 36.00% $ 36.00 Price per bag sold to retailers 2.40 2.16 20 21 22 Slotting Costs 23 Package Design Costs 24 Sales Salaries 25 Slotting/Package DesignSales Salaries Total Amort/Life 6,000,000 2,000,000 400,000 1 S 6,000,000.00 Expected slotting costs to be expensed in the first year 1 S 2,000,000.00 Expected packaging design costs paid in the first year S 400,000.00 Expected additional sales and marketing salaries to be paid Sales Volume (Cases): 27 28 First Month Sales Volume 29 Monthly Sales Growth Year 1 30 December Sales Volume 31 Sales Forecast Error Percent Cases Sold Annual Sales 65,000.00 Initial sales forecast for the first month 15,000.00 Sales growth per month first year 65,000 S 15,000 $ 230,000.00 25 Perecent possible forecast error The chicken or the egg-Financials (Template) V1 Q-Search Sheet Home Insert Page Layout Formulas Data Review View Conditional Formatting Format as Table Cell Styles 10 , ?-?? ?. % Times New R Paste BIU A AlignmentNumber Cells Editing Case Configuration.: 10 11 12 13 14 15 16 17 18 Pounds per Case Bags per Case 15 Expected pounds per case Expected number of bags per case 12 Sales Price/Coupon Costs/Commission: Percent/Per Bag Bags/Case Per Case Sales Price to Retailers (S per bag) Coupon Costs (S per bag) Commission (percent) 3.00 0.20 6.00% 12 S 12 $ 36.00% $ 36.00 Price per bag sold to retailers 2.40 2.16 20 21 22 Slotting Costs 23 Package Design Costs 24 Sales Salaries 25 Slotting/Package DesignSales Salaries Total Amort/Life 6,000,000 2,000,000 400,000 1 S 6,000,000.00 Expected slotting costs to be expensed in the first year 1 S 2,000,000.00 Expected packaging design costs paid in the first year S 400,000.00 Expected additional sales and marketing salaries to be paid Sales Volume (Cases): 27 28 First Month Sales Volume 29 Monthly Sales Growth Year 1 30 December Sales Volume 31 Sales Forecast Error Percent Cases Sold Annual Sales 65,000.00 Initial sales forecast for the first month 15,000.00 Sales growth per month first year 65,000 S 15,000 $ 230,000.00 25 Perecent possible forecast error

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

Handbook Of Energy Audits

Authors: Albert Thumann, Terry Niehus, William J. Younger

7th Edition

1420067915, 978-1420067910

More Books

Students also viewed these Accounting questions

Question

How is overtime computed for piece-rate employees?

Answered: 1 week ago

Question

b. What groups were most represented? Why do you think this is so?

Answered: 1 week ago