Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Billy's company sells 3 types of T-shirts: Astro, Bling, and Curious. Manufacturing Astros requires 2 minutes of machine time and 20 minutes of labor, and
Billy's company sells 3 types of T-shirts: Astro, Bling, and Curious. Manufacturing Astros requires 2 minutes of machine time and 20 minutes of labor, and costs $10. Brand Bling requires 2.5 minutes of machine time and 30 minutes of labor, and costs $14 to produce Brand Curious requires 3 minutes of machine time and 45 minutes of labor, and costs $18 to produce. There are 300 machining minutes available per day, 3750 labor minutes, and he has a budget of $3000. Brand Astro sells for $15, Brand Bling for $18, and Brand Curious for $25 To maximize daily profit, Billy builds the following Excel spreadsheet model to help determine the optimal production plan. In addition, the sensitivity report is also generated to facilitate the analysis Excel spreadsheet model: 1 Test 1 - Problem 4 3 Inputs Astro Bling Curious Total used Availability 5 6 7 8 Machine time (minutes) Labor (minutes) Cost (S) Price (S) 20 10 15 30 14 18 45 18 25 300 3750 1650 3750 3000 10 Production Plan Astro 12 Production quantity 13 14 Maximum Revenue 75 2375 Sensitivity analysis report: Variable Cells Fina Reduced Objective Allowable Allowable Decrease Cell SB$12 Production quantity Astro $C$12 Production quantity Bli D$12 Production quantity Curious Name Value Coefficient Increase 75 0 0 -1.583333333 18 1.583333333 25 1E+30 2.5 50 8.75 problem 4-2 pic Constraints Final Shadow Constraint AllowableAllowable Value Cell E$5 Machine time (minutes) Total used 300 5.833333333 SE$6 Labor (minutes) Total used SE$7 Cost (S) Total used Name Price R.H. Side Increase Decrease 3750 0.166666667 1650 3750 3000 75 750 1E+30 750 1350 If Billy can have the workers to work overtime for additional 10 labor hours in total and pay the workers $8/hour, is this a beneficial plan? And why? If Billy wants raise the price on Bling to $20 per shirt, will the optimal production plan change? And why? (Bonus Question +5 points) Billy has decided that he can raise the price on the Curious t-shirt by 10% without losing sales. If he raises the price, his revenue will increase by 10%. decrease by 10%. increase by $2.50 increase by $125
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