Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Paddington Station assembles two teddy bears. The Sleepy Model is more popular than the Standing Model. The company has the following information about the assembly
Paddington Station assembles two teddy bears. The Sleepy Model is more popular than the Standing Model. The company has the following information about the assembly of each: Single Unit Information StandingSleepyAssembly time hoursRetail price of one unitCost to produce unitProfit per unit The company has only $ and hours to assemble both models and you must make more Sleepys than Standings. Using the resources available as constraints, determine how many units of each model should be assembled by the company for maximum profits. Part II: Fixed Pricing Now let us look at using excel for linear programing to determine the optimal solution. Given the below demand equations, solve the following problem. A retailer has purchased ski parkas before the start of the winter season. The season lasts three months, and the retailer has forecast demand in each of the three months to beJanuary demand x January PriceFebruary demand x February PriceMarch demand x March PriceThe retailer has paid $ each for each parka but will return the unsold ones for $ each there is a $ return fee for each unsold parka Hint: Consider the unsold parkas x return fee in the Total Cost cellHint : Total Profit Total Revenue Total Cost Run a Fixed pricing models price for each month will remain the same for this problem. Determine what price to charge for each of the three months, in order to maximize profit. Fill in the appropriate cells with the numbers from this introduction. All other cells in the models must be filled in with formulas, not numbers.
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