Scribd
Upload
9 views4 pages

Monthly Inventory and Cost Analysis

The document shows inventory levels for 5 parts (A, B, C, D, E) from March to December. It also includes production and costs for the parts as well as assembled desks. The total profit was $1,605,230, which was calculated from total revenue of $4,170,000 minus total costs of $2,564,770.

Uploaded by

M.m.h no comments
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
9 views4 pages

Monthly Inventory and Cost Analysis

The document shows inventory levels for 5 parts (A, B, C, D, E) from March to December. It also includes production and costs for the parts as well as assembled desks. The total profit was $1,605,230, which was calculated from total revenue of $4,170,000 minus total costs of $2,564,770.

Uploaded by

M.m.h no comments
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Starting Inventory

Part A Part B Part C Part D Part E


March 0 0 0 0 0
April 0 0 0 0 0
May 0 0 0 0 0
June 0 0 0 0 0
July 600 120 360 4170 720
August 860 160 1110 3810 7620
September 1040 210 630 3330 6660
October 1120 230 2700 2700 5400
November 1160 310 2010 2010 4020
December 1040 360 1080 1080 2160

Inventory Cost
Part A Part B Part C Part D Part E
5 8 4 7 2
Ending Inventory Pa
Desks Demanded Desks Produced
Part A Part B Part C Part D Part E Part A
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 500
120 120 360 0 0 3810 0 500
160 160 540 0 630 3330 6660 500
210 210 620 0 0 2700 5400 500
230 230 660 0 2010 2010 4020 500
310 310 540 0 1080 1080 2160 500
360 360 320 0 0 0 0 0

Inventory Cost = 157070


Desks Production Cost = 723500
Parts Production Cost = 1684200
Total Cost = 2564770
Revenue Generated = 4170000
Objective Function
Total Profit = 1605230
Parts Ordered Production Cost / Unit
Part B Part C Part D Part E Desk Part A Part B Part C Part D Part E
0 0 0 720 0 0 0 0 0 50
0 0 4130 7620 0 0 0 0 110 40
90 360 0 0 0 0 220 70 130 55
160 1110 0 0 0 170 215 80 170 45
210 0 0 0 400 140 205 90 210 60
230 2700 0 0 400 150 195 20 180 35
310 0 0 0 450 140 200 80 190 0
360 0 0 0 500 130 200 80 0 0
0 0 0 0 600 160 0 0 0 0
0 0 0 0 600 0 0 0 0 0
Required Inventory each month
Part A Part B Part C Part D Part E
March 0 0 0 0 0
April 0 0 0 0 0
May 0 0 0 0 0
June 0 0 0 0 0
July 240 120 360 360 720
August 320 160 480 480 960
September 420 210 630 630 1260
October 460 230 690 690 1380
November 620 310 930 930 1860
December 720 360 1080 1080 2160

You might also like