Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You manufacture a widget that you sell for $5, it costs you $1.50 to make the product. Use goal seek to determine how many widgets

You manufacture a widget that you sell for $5, it costs you $1.50 to make the product. Use goal seek to determine how many widgets you have to sell to earn a profit of $3 500. Goal seek is not persistent so take a screen shot showing the goal seek box beside your solution.

plwase provide the formulas 

and the excel sheet

Step by Step Solution

3.54 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

You need to sell 1000 widgets to earn a profit of 3500 Amount in 100 years is 131500 ... 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

Step: 3

blur-text-image

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

Operations Management in the Supply Chain Decisions and Cases

Authors: Roger Schroeder, M. Johnny Rungtusanatham, Susan Goldstein

6th edition

73525243, 978-0073525242

More Books

Students also viewed these Operating System questions