Answered step by step
Verified Expert Solution
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
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 errorStep 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