Exercise 1 You own an internet firm and ship products throughout the US. Your clients understand...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Exercise 1 You own an internet firm and ship products throughout the US. Your clients understand that it will take 10-14 days for them to receive any item that they purchase through your website. You have negotiated a flat rate shipping rate. However, your flat rate shipping rate is determined by the day of the week that the item is shipped and what region of the country the item is shipped to. Shipping rates by day of the week and region are listed below. While your shipping department is extremely efficient it can only ship the following units per day: T Monday Tuesday Wednesday Thursday Friday Saturday All orders must ship within seven days of receipt. T Shipping costs -in dollars T Region 1900 T 2000 T Monday Tuesday Wednesday 1800 T 1700 T 1500 T Solver T 1200 T Units Ordered East 1600 Southeast 1500 Midwest 2000 Southwest 1500 West 1700 Northeast 1600 Monday Tuesday Wednesday Thursday Friday 5 5 4 7 8 9 6 5 5 6 70 8 40 4 3 6 7 11 78 70 70 9 10⁰ 8 8 78 8 8 9 15 Saturday 9 8 7 12 12 20 In addition to the shipping costs there is a labor cost per item to ship each item. The labor cost varies by the day of the week: T $1.75/unit $1/unit T $1/unit T дддд Д Thursday Friday Saturday There is also a fixed cost to operate the warehouse of $6,000 per month, a fixed cost for support staff of $7,000 per month, and a commission paid to the shipping consolidator of 10% of gross shipping costs for the week (not counting overhead). T You also can't ship all of one location's merchandise on the same day (lowers the risk) T $1/unit $2/unit $2.5/unit T Note: make sure that you handle fixed and variable costs appropriately. Keep in mind that you are calculating the costs for a week. T You need to find the lowest shipping costs for the company to ship the units listed in the above schedule. Your spreadsheet must include an answer report. T Exercise 1 You own an internet firm and ship products throughout the US. Your clients understand that it will take 10-14 days for them to receive any item that they purchase through your website. You have negotiated a flat rate shipping rate. However, your flat rate shipping rate is determined by the day of the week that the item is shipped and what region of the country the item is shipped to. Shipping rates by day of the week and region are listed below. While your shipping department is extremely efficient it can only ship the following units per day: T Monday Tuesday Wednesday Thursday Friday Saturday All orders must ship within seven days of receipt. T Shipping costs -in dollars T Region 1900 T 2000 T Monday Tuesday Wednesday 1800 T 1700 T 1500 T Solver T 1200 T Units Ordered East 1600 Southeast 1500 Midwest 2000 Southwest 1500 West 1700 Northeast 1600 Monday Tuesday Wednesday Thursday Friday 5 5 4 7 8 9 6 5 5 6 70 8 40 4 3 6 7 11 78 70 70 9 10⁰ 8 8 78 8 8 9 15 Saturday 9 8 7 12 12 20 In addition to the shipping costs there is a labor cost per item to ship each item. The labor cost varies by the day of the week: T $1.75/unit $1/unit T $1/unit T дддд Д Thursday Friday Saturday There is also a fixed cost to operate the warehouse of $6,000 per month, a fixed cost for support staff of $7,000 per month, and a commission paid to the shipping consolidator of 10% of gross shipping costs for the week (not counting overhead). T You also can't ship all of one location's merchandise on the same day (lowers the risk) T $1/unit $2/unit $2.5/unit T Note: make sure that you handle fixed and variable costs appropriately. Keep in mind that you are calculating the costs for a week. T You need to find the lowest shipping costs for the company to ship the units listed in the above schedule. Your spreadsheet must include an answer report. T
Expert Answer:
Answer rating: 100% (QA)
Well Firstly Modelling the Data into a Report Format is the key solving point Using solver would be ... View the full answer
Related Book For
Posted Date:
Students also viewed these economics questions
-
You own a U.S. exporting firm and will receive 10 million Swiss francs in one year. Assume that interest parity exists. Assume zero transactions costs. Today, the one-year interest rate in the U.S....
-
Country A and Country B have identical population growth rates of 1 percent per annum, and everyone in each country always works 40 hours per week. Labor productivity grows at a rate of 2 percent in...
-
Listed below are accounts to use for transactions (a) through (j), each identified by a number. Following this list are the transactions. You are to indicate for each transaction the accounts that...
-
(a) ABC is a company that manufactures computer desk. The total costs (in RM'000) when x units of computer desk are produced is given by C(x) = 12x 3 - 198x 2 + 1080x Find the level of x that the...
-
In what ways, if any, does a unionized employee have greater protection from dismissal than a nonunion employee in the Canadian model? Do you think that is fair or not? Why?
-
Consider a Feistel cipher composed of sixteen rounds with a block length of 128 bits and a key length of 128 bits. Suppose that, for a given \(k\), the key scheduling algorithm determines values for...
-
For the adiabatic flash operation shown in Figure 10.34, calculate the following: (a) Change in availability function \(\left(T_{0}=100^{\circ} \mathrm{F} ight)\) (b) (b) Lost work (c) Thermodynamic...
-
Mothers Bottlers, Inc., is a small bottling company that bottles and sells cold teas for $5 per unit. The cost of each unit follows: Materials . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
How is the North American wholesale club industry changing? What are the underlying drivers of change and how might those forces individually or collectively make the industry more or less attractive...
-
You want to purchase a home based upon your current salary you decide that you can afford $2000.00 per month. Your bank has approved you for a (30 year) loan at an interest rate of 5%. 1) Based upon...
-
The following table shows a profit-maximizing producer's marginal costs. The firm is operating in a perfectly competitive market and has fixed costs of $500. Quantity 8 1345678 Marginal Cost (S) 200...
-
Why do people sometimes use credit to pay for items instead of just using cash? When applying for credit, is it preferable to receive a low interest rate or a high interest rate?...
-
Calculate the induced voltage across a 1.5 mH inductor when the current is changing at a rate of 12.0 mA per microsecond. O 3.0 mV 30 mV 18 V 3.00 V
-
The hierarchical system of classification is intended to be a map of evolution. Explain this statement. What is implied about species that occur on the same branch of a phylogenetic tree?
-
Preparing Entry to Issue Common Stock On June 30, Ebae Inc. issued 120 shares of $1 par value common stock for $12 per share. Prepare Ebae's June 30 journal entry for stock issuance. Date Account...
-
What is an optimal hedge and how do we calculate it? Compute the number of contracts we need in the hedge. How do we decide if we should implement the hedge? Why? Explain in full detail. Suppose you...
-
Discuss consumer behaviour as afield of study in your own words? Justify your opinion on the impact on consumer behaviour in relation to shopping at Woolworths. Let our customers down': Woolworths...
-
Write a program that initializes an array. It inputs a value from the user and searches the number in the array.
-
The subsidiaries of Forest Company produce goods in the U.S., Germany, and Australia, and sells the goods in the areas where they are produced. Foreign earnings are periodically remitted to the U.S....
-
Assume that interest rate parity exists. The annualized interest rate is presently 5% in the U.S. for any term to maturity, and is 13% in Mexico for any term to maturity. Dokar Co. (a U.S. firm) has...
-
Assume that the one year interest rate in Canada is 4 percent. The one year U.S. interest rate is 8 percent. The spot rate of the Canadian dollar (C$) is $.94. The forward rate of the Canadian dollar...
-
Analyze the transient problem with the Dirichlet condition for a long cylinder and for a sphere. Derive expressions for the eigenfunctions, eigenconditions, and eigenvalues. Find the series...
-
Consider the problem of transient heat transfer with a constant heat source in a slab. Show that the governing equation in dimensionless form is \[\begin{equation*}\frac{\partial \theta}{\partial...
-
Eigenvalues without pain: CHEBFUN code. Eigenfunctions can be derived using the CHEBFUN with MATLAB since it has an overloaded eig function. The following code solves for the eigenfunctions of the...
Study smarter with the SolutionInn App