Question: use excel to analyze the shipment problem. please show all steps and formulas TOTAL COST ANALYSIS TO DETERMINE SHIPMENT RATE The traffic manager of the

use excel to analyze the shipment problem. please show all steps and formulas

TOTAL COST ANALYSIS TO DETERMINE SHIPMENT RATE The traffic manager of the Monarch Electric Company has just received a rate reduction offer from a trucking company for the shipment of fractional horsepower motors to the company's field warehouse. The Proposal is a rate of $3 per hundredweight (cwt) if a minimum of 40,000 pounds is moved in each shipment. Currently, shipments of 20,000 pounds out more are moved at a rate of $5 per ewt. If the shipment size falis belom 20,000 pounds, a rate of $9 per cwt. applies. To help the trsffic manager make a decision, the following additional information has been gathered annual demand on Warehouse 5,000 motorn per year Warehouse replenishment orders orders per year de light of each motore crated 1 lb, per motor Standard cost of motor watch 31200 perto stock seplenishment_order=handling con S15 per order 250 per ye Dry Carrying Cosas percentage of ourage value of inventory hand for Handing ostvarno 50.30 peta Warehouse Space Unlimited should the company out the state asa

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 General Management Questions!

Please! show all steps and formulas in excel. Complete the following table and compute the incremental cash flows associated with the replacement of the old equipment woth the new equipment. At times...

8.1. Dulles Electric Company buys 1 million tons of coal annually to burn at its power plant. The company wants to invest in a unit train that will haul coal from the mine to the power house, where...

Hello I have been having a problem with this excel assignment and I had posted it yesterday but I haven't get helped since please help me the excel details instruction is attacked SDSU Accounting...

Please analysis the case study must including identification of issues, situational analysis, identification of recommendations, financial risk analysis, total cost analysis, supplier evaluation and...

MGMT-6082 Domestic and International Sourcing Mid Term Case Smart Phone Corporation (25%) Individual Submission (60%) Students are to submit their individual preparation on the Mid Term Case 72 hours...

Based on the information given in the case study, Share brief answers to below Supplier Financial Analysis Worksheet Purchasers assess supplier financial health for several reasons. The most...

ac3 Watch the movie "Up in the Air" starring George Clooney. Pay close attention to the role of Natalie as a Business Analyst. As you are watching the movie, jot down your answers to the following...

113``` IST 461 - Business Analysis Assignment 3 Due by midnight on Sunday of the week it has been assigned. Consider the following scenario: "Take Me Away", a nation-wide Vacation Rental Company, is...

q qq sure answers This was my initial post that my professor said was not an adequate response: Economic variables that lead to monopolies include product differentiation, advertising and marketing...

(a) (b) (c) (d) You are given a voltmeter, micro-ammeter, a 12 volt DC battery, enough connecting wires, a variable resistor, a switch, and a resistor of 100 ohms. Draw the symbols of all these...

Consider X, Y with joint density fX,Y(x, y) = 1/2500(10 - x)(10 -y), for 0 x 10, 0 y 10, and fxy(x,y) = 0 otherwise. a. Find P(X 9). c. Find P(X > 9,Y > 9). d....

May 2 4 : Returned damaged merchandive purchaned on May 2 1 , neowiving a credit meme from the selier for s 5 , 9 0 0 .

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...