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

ekkarill92 answered 1 year ago
Next > < Previous

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...
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...
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....
Maria is the sole proprietor of an antique store that is located in a rented warehouse....
Maria is the sole proprietor of an antique store that is located in a rented warehouse. The business has a          $ 200,000 outstanding loan with the local bank but no other debt obligations. Last week, the loan, which has a monthly payment of $ 1,500, was not paid. There are no specific assets pledged as security for the loan. Due to a sudden and unexpected downturn in the economy, the store is just unable to generate sufficient funds to pay the...
Maria is the sole proprietor of an antique store that is located in a rented warehouse....
Maria is the sole proprietor of an antique store that is located in a rented warehouse. The business has a $ 200,000 outstanding loan with the local bank but no other debt obligations. Last week, the loan, which has a monthly payment of $ 1,500, was not paid. There are no specific assets pledged as security for the loan. Due to a sudden and unexpected downturn in the economy, the store is just unable to generate sufficient funds to pay...
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,...
Betty's Book and Music Store has two service departments, Warehouse and Data Center. Warehouse Department costs...
Betty's Book and Music Store has two service departments, Warehouse and Data Center. Warehouse Department costs are allocated on the basis of warehouse-hours. Data Center Department costs are allocated based on the number of computer hours. The costs of departments, warehouse-hours and number of computer hours are as follows: Support Departments Operating Departments Warehouse Data Center Music Books Departmental costs $ 60,000 $40,000 $60,000 $70,000 Warehouse-hours - 400 200 400 Computer hours 250 - 375 375 The total cost accumulated...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT