a) What would be the total cost, revenue and profit for a weekly volume of 10,000 bottles? (b) What is the break-even volume? (c) Set the problem in Excel, and use Goal Seek to confirm your answer in parts (a) and (b). (d) Suppose the company has a goal to make a weekly profit that is at least 25% of the revenue. What level of output satisfies this goal? Use the Excel Goal Seek to answer this question, and submit your printout. (e) Suppose the weekly demand for the new product is 3,500 bottles, that is, the company could only make and sell 3,500 bottles each week. Given the same fixed cost and retail price, how low should the variable cost be to realize the same goal in part (d)
hey i have completed qustion A but was wondering if i could get help with the rest of the qustions. the qustions are below this. thank you.
A company that produces cleaning products is considering a proposal to begin production of a new detergent that
would cost $1 a bottle to make and distribute, and retail for $2.19 a bottle. Fixed cost for the operation would be
$3000 a week. Assume that all output can be sold.
(a) What would be the total cost, revenue and profit for a weekly
volume of 10,000 bottles?
(b) What is the break-even volume?
(c) Set the problem in Excel, and use Goal Seek to confirm your
answer in parts (a) and (b).
(d) Suppose the company has a goal to make a weekly profit that
is at least 25% of the revenue. What level of output satisfies
this goal? Use the Excel Goal Seek to answer this question, and
submit your printout.
(e) Suppose the weekly demand for the new product is 3,500
bottles, that is, the company could only make and sell 3,500
bottles each week. Given the same fixed cost and retail price,
how low should the variable cost be to realize the same goal in
part (d)
Step by step
Solved in 7 steps with 19 images
