Question
Hi, please send the answer in excel file format, I just badly need your help. Please see the attached photo below. I wont give you
Hi, please send the answer in excel file format, I just badly need your help. Please see the attached photo below. I wont give you a thumbs up (helpful) IF you dont send the answer in excel file format or google drive link.Thank you so much
The average cost/unit for the production of a particular component at a manufacturing plant varies with the number of units produced in each batch. The data are given below.
Number of units produced Cost/Unit
0-49 37.72
50-100 25.02
Suppose the selling price of each unit is $35.
a.Build a model to calculate the profit of the manufacturing industry if the demand is 20.
b.Construct a data table that shows the profit per unit as a function of demand if the demand ranges between 20 units through 80 units in increments of 10 units.
C.Use a two-way data table to show how the profit changes as a function of demand and the selling price of the product. Vary the demand from 20 units to 80 units in increments of 10 units and selling price from
$30 to $40 in increments of $2.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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