Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) A bakery sells its pies for $7.00 each. The bakery incurs a daily fixed cost of $500 which includes salaries and rental. The variable

image text in transcribed
1) A bakery sells its pies for $7.00 each. The bakery incurs a daily fixed cost of $500 which includes salaries and rental. The variable cost per pie is $2.50. Use Goal Seek to compute the number of pies (X) that must be baked daily in order to break even if the variable cost per pie increases to $3.00. Question 2: A manufacturer of travel pillows must determine the production plan for the next production cycle. He wishes to make at least 300 of each of the three models that his firm offers and no more than 1,200 of any one model. The specifics for each model are shown in the following table. Formulate this Product Mix problem by using L.P and solve it by using Excel. Your solution should answer the following questions: a) Define the decision variables and their unit of measurement ( 2 points) b) State the objective function of the problem 2 points for correct coefficient identification and 4 points for correct goal identification (min vs max)) c) State the constraint equations. Which constraints are binding? (2 points) d) Solver Solution: How many pillows of each type should be manufactured in order to maximize total profit? (1.5 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions