Answered step by step
Verified Expert Solution
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
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
Get Instant Access with AI-Powered 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