You now own a manufacturing firm and your firm makes 6 products. Each product has the...

Transcribed Image Text:

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. 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.

Answer rating: 100% (QA)

All calculations for scenarios have been done keeping The Base column as base This col... View the full answer