Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need to determine how to calculate the blank columns on the spreadsheet below. Month Profit Cost of Goods Total Revenue Profit as a %
I need to determine how to calculate the blank columns on the spreadsheet below.
Month | Profit | Cost of Goods | Total Revenue | Profit as a % of COGS | % Increase/Decrease in Profit Over Time | Change in COGS | % Increase/Decrease in cost over time |
January | -18920 | 23920 | $5,000.00 | 0 | |||
February | -16420 | 23920 | $7,500.00 | 0 | |||
March | -1420 | 23920 | $22,500.00 | 0 | |||
April | -11420 | 23920 | $12,500.00 | 0 | |||
May | -10960 | 18460 | $7,500.00 | 0 | |||
June | 4040 | 18460 | $22,500.00 | 0 | |||
July | 5405 | 17095 | $22,500.00 | 1365 | |||
August | 7905 | 17095 | $25,000.00 | 0 | |||
September | 12905 | 17095 | $30,000.00 | 0 | |||
October | 12905 | 17095 | $30,000.00 | 0 | |||
November | 12905 | 17095 | $30,000.00 | 0 | |||
December | 12905 | 17095 | $30,000.00 | 0 |
Step 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