Question

In: Accounting

A certain dealer owns a warehouse that can store a maximum of 600 units of a...

A certain dealer owns a warehouse that can store a maximum of 600 units of a given commodity. He has on hand 100 units of the commodity and knows the buying and selling price for the next 5 time periods. They are:

PERIOD

BUYING PRICE

SELLING PRICE

1

15

16

2

17

17

3

21

20

4

19

19

5

16

20

He is permitted to sell up to the amount that he has in his warehouse at the beginning of each period. If he buys in a given period, delivery will be made so that it is in storage at the beginning of the next period. Let (Xi, Yi) denote the amount he buys and sells in time-period i respectively. What is the optimal buying\selling strategy.

Formulate the linear programming problem.  

Develop a spreadsheet and solve the problem.

Solutions

Expert Solution

See the table below for solution :

As per working given below situation 2 i.e Buying price 17 & Selling price 17 is the best resuting in profit.

Period

Opening

Stock

Purchase price of

Opening Stock

Total Purchase Cost of opening stock

Additional Purchase Qty

Purchase

Price of Additional purchase qty

Total Purchase Cost of additional qty purchased

Total Selling Price

(Restricted to purchase cost of opening stock)

Selling

Price

Sale Qty

Profit (Selling price - Buying Price) * Qty sold

Closing

Stock in Qty

Closing Stock in Value

1

100

15

1500

500

15

7500

1488

16

93

(16-15)*93 = 93

507

7*15 = 105

500*15 = 7500

2

507

15

7605

93

17

1581

7599

17

447

(17-15)*500 = 894

153

60*15 = 900

93*17 = 1581

3

153

15 & 17

2481

447

21

9387

2480

20

124

(20-15)*60 + (20-17)*64 = 492

476

29*17 = 493

447*21 = 9387

4

476

17 & 21

9880

124

19

2356

9044

19

476

(19-17)*29 + (19-21)*457= -856 (loss)

124

124*19 = 2356

5

124

19

2356

476

16

7616

2340

20

117

(20-19)*117 = 117

483

7*19 = 133

476*16 = 7616


Related Solutions

Warehousing Corp. owns a large warehouse that can be subdivided into numerous subsections by inserting removable...
Warehousing Corp. owns a large warehouse that can be subdivided into numerous subsections by inserting removable wall. It leases out different portions of storage space to its customers based on their needs. Manufacturing Corp. contracts with Warehousing Corp. to reserve 1,000 square feet of space to store excess inventory for a three-year period. The contract specifies that Manufacturing Corp.’s inventory will be stored in an identified location in the warehouse. However, Warehousing Corp. has the right to shift Manufacturing Corp.’s...
A thief robbing a store can carry a maximum weight of W in their knapsack. There...
A thief robbing a store can carry a maximum weight of W in their knapsack. There are n items and ith item weighs wi and is worth vi dollars. What items should the thief take to maximize the value of what is stolen? The thief must adhere to the 0-1 binary rule which states that only whole items can be taken. The thief is not allowed to take a fraction of an item (such as ½ of a necklace or...
The annual demand for a certain product sold in a department store is 1,000 units. Ordering...
The annual demand for a certain product sold in a department store is 1,000 units. Ordering cost per order is $50, holding rate is 40%, and unit cost is $200. The department store currently is ordering every two months, but now is offered the following quantity discount scheme: For an order of up to 99 units no discount. For an order up to 699 units-a discount of 25%, and for a larger order -a discount of 30%. What is the...
The annual demand for a certain product sold in a department store is 1,000 units. Ordering...
The annual demand for a certain product sold in a department store is 1,000 units. Ordering cost per order is $50, holding rate is 40%, and unit cost is $200. The department store currently is ordering every two months, but now is offered the following quantity discount scheme: For an order of up to 99 units no discount. For an order up to 699 units-a discount of 25%, and for a larger order -a discount of 30%. What is the...
An Antique dealer needs to store records of the items in the inventory into a stack...
An Antique dealer needs to store records of the items in the inventory into a stack (the dealer believes that keeping items longer will be beneficial; nonetheless, the business logic here is not important!). Besides the usual push() and pop(); the dealer needs to always know what is the most expensive item in the inventory/stack. You are hired to implement a new method, called max(), which returns the current maximum value for any item in the stack. Notice that the...
Frank’s Foods has a warehouse that supplies products to its store locations. The warehouse has two...
Frank’s Foods has a warehouse that supplies products to its store locations. The warehouse has two service departments, Information Services (S1) and Operation Support (S2), and two operating departments, Order Processing (P1) and Delivery (P2). As an internal auditor, you are checking the company’s procedures for cost allocation. You find the following cost allocation results for September:    Costs allocated to P1 $ 41,000 from S1 ? from S2 Costs allocated to P2 ? from S1 $ 26,700 from S2...
You are a warehouse manager who has observed that the current warehouse operation has certain weaknesses....
You are a warehouse manager who has observed that the current warehouse operation has certain weaknesses. You have found new solutions which would replace the earlier ones in order to patch up these weaknesses. While performing a qualitative analysis of the revised plan for the operations, which of the following options would you consider? The safety of the staff if the new solutions are implemented The difficulty of managing the new solutions The safety of the inventory itself with the...
Define an array named PeopleTypes that can store a maximum of 50 integer values that will be entered at the keyboard.
Define an array named PeopleTypes that can store a maximum of 50 integer values that will be entered at the keyboard. Enter a series of 1s, 2s,3s and 4s, into the array, where a represent an infant, a 2 represent a child, a 3 represents a teenager, and a 4 represents an adult who was present at a local school functionp.412 PE 4Write a C function that finds and displays the maximum value in a two dimensional array of integers....
Harry (who owns the houses and is being sued by Rebecca) is also a furniture dealer...
Harry (who owns the houses and is being sued by Rebecca) is also a furniture dealer in town. Harry calls up another merchant and says he will sell 30 dressers for the standard price and the other merchant Sam says you have a deal. (The standard price is $80 each.) Harry then sends an email to the other merchant confirming what he just said, and says the items will be sent in one week. The other merchant promptly responds via...
When things are operating​ properly, a certain Internet bank can process a maximum of 28 electronic...
When things are operating​ properly, a certain Internet bank can process a maximum of 28 electronic transfers every minute during the busiest periods of the day. If it receives more transfer requests than​ this, then the​ bank's computer system will become so overburdened that it will slow to the point that no electronic transfers can be handled. If during the busiest periods of the day requests for electronic transfers arrive at the rate of 180 per​ 10-minute period on​ average,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT