Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

The Routledge Companion To Accounting And Risk

Authors: Margaret Woods

1st Edition

1138860123, 9781138860124

More Books

Students also viewed these Accounting questions

Question

What should be the primary objective of managers?

Answered: 1 week ago