Answered step by step
Verified Expert Solution
Link Copied!

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,

image

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

Fundamental Accounting Principles

Authors: John Wild, Ken Shaw, Barbara Chiappetta

22nd edition

9781259566905, 978-0-07-76328, 77862279, 1259566900, 0-07-763289-3, 978-0077862275

More Books

Students also viewed these General Management questions