Question: Question 1: PLEASE SHOW ALL WORK Suppose you are told that your companys costs structure looks like the following: Cost (Q) = 2SF*(1000 100Q +

Question 1: PLEASE SHOW ALL WORK

Suppose you are told that your companys costs structure looks like the following:

Cost (Q) = 2SF*(1000 100Q + 4Q2)

SF = Seasonal Factor (decimal) Takes on values from 0-2 by 0.2 (0, 0.2, 0.4, 1.8, 2.0)

Q = Quantity of Units Sold

If you are told that SF = 1.0 find the following.

(a) What is the number of units needed to be sold in order to have costs equal to $200,000?

(b) If you are told that SF = 0.4, illustrate in an excel spreadsheet what projected costs would be for 0 to 500 units going by 25 units.

(c) Finally, create a scatterplot of your results in part (b). Make sure to label the scatterplot. What does this show you about costs as you continue to produce more units?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!