Question: Please show ALL work using EXCEL Create a two-way model The Public Works Department in Georgetown has a mechanical shop liable for selling an inspector,

Please show ALL work using EXCEL

Create a two-way model The Public Works Department in Georgetown has a mechanical shop liable for selling an inspector, called Vehicle Testing Monitor 2016 (VTM 2016), which will be retailed for $500. The director, Erick, wants a model to help him obtain an adequate number of VTM2016. Erick can get the testers from the manufacture, but the total value depends on the quantity requested, as shown in Table 1. Erick is uncertain about the demand for the VTM2016. He predicts that the need could be the range from 300 to 2000. Also, the next year VTM 2017 will be in the market, if Erick has VTM2016 left, he will put them on clearance for $200, at which price it considers all leftovers will be sold.

the unit cost is $450, if the number ordered is <100

the unit cost is $400, if the number ordered is 100-200

the unit cost is $350, if the number ordered is 200-300

the unit cost is $300, if the number ordered is 300-400

the unit cost is $250, if the number ordered is 400-500

the unit cost is $200, if the number ordered is 500-600

the unit cost is $150, if the number ordered is >600

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Create a two-way model The Public Works Department in Georgetown has a mechanical shop liable for selling an inspector, called Vehicle Testing Monitor 2016 (VTM 2016), which will be retailed for...

Please help me resolve I am struggling on solving the answer The Public Works Department in Georgetown has a mechanical shop liable for selling an inspector, called Vehicle Testing Monitor 2016 (VTM...

The Public Works Department in Georgetown has a mechanical shop liable for selling an inspector, called Vehicle Testing Monitor 2016 (VTM 2016), which will be retailed for $500. ^The director, Erick,...

^The Public Works Department in Georgetown has a mechanical shop liable for selling an inspector, called Vehicle Testing Monitor 2016 (VTM 2016), which will be retailed for $500. ^The director,...

Question: Do a two-way data table model and explain how a joint change in the number of VTM2016 ordered, and the number of demands impacts their profit. The Public Works Department in Georgetown has...

Building and Construction BSBSMB401 Establish legal and risk management requirements of small business Learner Materials and Assessment Tasks Table of Contents About BSBSMB401 Establish legal and...

Need to give a few strategic decisions for the Role of VP- R&D - Tesla case study ESE Business School IES865 University of Navarra September 2021 Tesla in the 2020s: Moment of Truth for the "Master...

few strategic decisions for the Role of VP- Research & Development - Tesla Case study ESE Business School IES865 University of Navarra September 2021 Tesla in the 2020s: Moment of Truth for the...

***READ THIS FIRST*** I need the questions for Part 1 AND Part 2 answered for this case study. The answers must be well-written, detailed, and must answer each question fully with examples from the...

Outline a preparation of benzylamine using the Gabriel synthesis.

Obtain the y parameters of the two-port network in Fig. 19.83. 1 sa 5 92 5

Question 6 1 pts A bond has a $ 1 , 0 0 0 par value, makes anenal interest payments of $ 1 0 0 , has $ years to maturity, cannot be called, and is not expected to defelel. The bond should sell at a...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

(Appendices) SALES, SALES RETURNS, AND SALES ALLOWANCES. The contractor sales department of a Builders Square store in suburban Chicago had the following salesrelated transactions on a recent day: a)...

(Appendices) DISCOUNT POLICY AND GROSS MARGIN. Compton Electronics sells Motorola cellular phones. During 19x8, Compton sold 1,000 units for $300 per unit. Each unit costs Compton $180. At present,...

(Appendices) INTERNAL CONTROL FOR SALES. Alcoa Building Products distributes aluminum siding and related building products to building contractors, all of whom purchase on credit. LO6 REQUIRED: List...