Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Linda Smith Bamber, Karen Wilken Braun, Jr. Harrison, Walter T.

1st Edition

0138129711, 978-0138129712

More Books

Students also viewed these Accounting questions

Question

Explain how SIHRM is linked to different global business strategies

Answered: 1 week ago