Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You now own a manufacturing firm and your firm makes 6 products. Each product has the following cost components: Material & Labor. In addition,
You now own a manufacturing firm and your firm makes 6 products. Each product has the following cost components: Material & Labor. In addition, there is a fixed cost for the firm. Cost of item in production units Production ZA units Material Units Labor units 2 1 Production units cost per unit Material Labor Retail Price Quantity 500 Fixed cost: $7 $5 $30 XB 2 1 5 $4 $25 750 YC 1 1 4 $5 $17 650 TD 1 2 5 $6 $20 900 SE 3 2 6 $5 $45 250 RG 1 1 6 $5 $18 600 $12,000 Use scenario manager to conduct the following stress tests by determining the effect of the following scenarios upon net profit: # 1 Increase retail price, material cost and labor cost by 12%. #2 Increase retail price by 5%, increase labor cost by 7% and hold material cost static. # 3 Decrease retail price by 5%, increase labor cost by 5% and increase material cost by 5%, increase fixed cost by $1,000 #4 Decrease retail price by 10%, decrease material cost by 5% and decrease fixed cost by $2,000. #5 Increase retail price by 15%, material cost by 12%, decrease labor cost by 2% and increase fixed cost by $5,000 Please make sure that all of your changing and output cells are named by using the define name function.
Step by Step Solution
★★★★★
3.52 Rating (155 Votes )
There are 3 Steps involved in it
Step: 1
All calculations for scenarios have been done keeping The Base column as base This col...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