Full Throttle orders a key part from an external supplier and needs to determine the optimum...

Full Throttle orders a key part from an external supplier and needs to determine the optimum ordering plan for the next 5 weeks. The parts are ordered in bins that contain 200 parts per bin. They can order up to 4 bins per week. The planning team estimated the demand of parts of the next 5 weeks and the supplier gave them the following cost per bin for the next 5 weeks.

Week	1	2	3	4	5
Parts Demanded	750	425	300	575	700
Cost Per Bin	$2,000	$1,670	$1,840	$2,190	$1,680

They currently do not have any parts on hand and will incur a carrying cost of $7.50 per part based on average inventory. Develop an Excel model and solve using Solver to find their optimum ordering strategy.

Expert Solution

Step 1: Create an Excel model in this way

Step 2:

Solver Parameters

Press Solve

Step 3:

"Pressing solve button Yellow boxes show the values"

In solver results box press ok by keeping option as keep solver solution...

Thank you

"Please give a Thumbs up it will be so helpful"

keosha answered 5 months ago

The WT Company needs to order a part from a supplier. The supplier has the following...

The WT Company needs to order a part from a supplier. The supplier has the following price schedule for the part. The parts cost $300 each for orders of 500 or fewer units; for orders between 500 and 1,000 units, the first 500 cost $300 each and the remaining amount cost $290 each; for quantities of 1,000 and over the first 500 cost $300 each, the next 500 cost $290 each, and the remaining amount cost $280 each. The accounting...

ABC needs $719,000 to take advantage of a special offer from their key supplier. The loan...

ABC needs $719,000 to take advantage of a special offer from their key supplier. The loan will allow them to reduce their accounts payable and begin taking trade discounts. They plan to repay the loan in one year out of their normal operating cash flows. The bank has offered a one-year discount loan at an annual percentage rate of 5.25%. Given this information, how many dollars of interest is ABC expected to pay for this arrangement?

Explain the key ideas to be kept in mind before moving from part-time to full-time entrepreneurship.

A company purchases a particular component from an external supplier. The demand for the component is...

A company purchases a particular component from an external supplier. The demand for the component is estimated to be 475 units per month. The cost of placing an order with the supplier is £500. The component can be purchased from the supplier at a price per unit of £63 if so desired. However the supplier also offers a quantity discount such that if the company orders 800 or more in each order the price per unit is only £60. The...

On May 1, Year 1, KLM orders equipment from a supplier in Luxemburg for €100,000 with...

On May 1, Year 1, KLM orders equipment from a supplier in Luxemburg for €100,000 with delivery scheduled for October 1, Year 1. Payment is due on December 31, Year 1. On May 2, Year 1 KLM enters into an 8-month forward contract with its bank at a rate of €1 = $1.38 to purchase €100,000 on December 31, Year 1, the date the accounts payable is due. The equipment is delivered on October 1, Year 1, and immediately put...

Furniture Depot orders a certain brand of mattress from its supplier and sells the mattresses at...

Furniture Depot orders a certain brand of mattress from its supplier and sells the mattresses at its retail location. The store currently orders 40 mattresses whenever the inventory level drops to 20. The cost to hold 1 mattress in inventory for one day is $0.75. The cost cost to place an order with the supplier is $80, and inventory is 30 mattresses. The daily demand probabilities are shown in the following table: Daily Demand Probability 2 0.08 3 0.14 4...

APC is a sales department consists of 17 full-time and part-time employees. They receive orders via...

APC is a sales department consists of 17 full-time and part-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in. Because ABC is a wholesaler, the vast majority of its business is conducted on a credit basis. The process begins in the sales department, where the sales clerk enters the customer’s order into the centralized computer sales order system. The computer and file server are housed in APC is small data processing department. If the customer...

QUESTION 1 A local electrical company orders a special type of widget from an Asian supplier...

QUESTION 1 A local electrical company orders a special type of widget from an Asian supplier at a cost of $8.00 per widget. The company has a daily demand of 100 widgets with a standard deviation of 25 widgets. Annual holding cost is $2.50 per widget and cost to place an order of $15. It takes 7 days to receive an order and the company operates 250 days for the year. The manager has set a 96% service level. Determine...

Determine the bond orders of (a) S2, (b) Cl2, and (c) NO from their molecular orbital...

Determine the bond orders of (a) S2, (b) Cl2, and (c) NO from their molecular orbital configurations and compare the values with the bond orders determined from Lewis structures. (NO has orbitals like those of O2)

A manufacturing company receives orders for engines from two assembly plants. Plant I needs at least...

A manufacturing company receives orders for engines from two assembly plants. Plant I needs at least 45 engines, and plant II needs at least 32 engines. The company can send at most 140engines to these assembly plants. It costs $30 per engine to ship to plant I and $40 per engine to ship to plant II. Plant I gives the manufacturing company $20 in rebates toward its products for each engine they buy, while plant II gives similar $10 rebates....

Question