We have the following data: ACCOUNTING INFORMATION MERCHANDISE INSURANCE $ 5400.68 MONTHLY EXTRA INVENTORY MOVEMENT GASOLINE DUE
Fantastic news! We've Found the answer you've been seeking!
Question:
We have the following data:
ACCOUNTING INFORMATION
MERCHANDISE INSURANCE $ 5400.68 MONTHLY
EXTRA INVENTORY MOVEMENT
GASOLINE DUE TO INVENTORY QUANTITY
FORKLIFT / SPARE PARTS, SURVEY REGISTRATION EXPENSES. $ 32,000.00 MONTHLY
AVERAGE CURRENT INVENTORY: 8 HOPPERS / . 1 HOPPER = 28 KG
Cost to order material 10,000.00 USD
Machine start 3,298.62 USD
Increase in electricity cost due to more than 5 starts per month 88,552.00 USD
Monthly warehouse rent 28,000.00 USD
Production capacity 40,000.00 KGS / DAY
Expected deliveries current 2 WEEKS
π? INVESTIGATE HOW IT IS EVALUATED
π˄? 1,000 MXN / WEEK
Raw material orders in batches of 28,000 KGS / ORDER
PRODUCT | DELIVERY DATE | GROSS WEIGHT (kgs) | COST / KG | SALES PRICE /KG |
X | 08/01/18 | 7128 | 33.9286858 | 41.48 |
X | 08/01/18 | 18332.16 | 35.7 | 44.41 |
X | 08/01/18 | 63349.44 | 35.7 | 44.48 |
X | 08/01/18 | 7140 | 35.7 | 43.5 |
X | 08/01/18 | 3564 | 33.9849349 | 40.07 |
X | 08/01/18 | 10710 | 35.7 | 43.65 |
X | 08/01/18 | 10710 | 35.7 | 44.28 |
X | 13/01/18 | 26752 | 35.7 | 42.97 |
X | 20/01/18 | 21596.4 | 35.7 | 44.43 |
X | 20/01/18 | 28507.248 | 33.6898901 | 42.37 |
X | 20/01/18 | 14390.4 | 33.6898901 | 42.06 |
X | 22/01/18 | 63317.76 | 33.6898901 | 39.93 |
X | 28/01/18 | 24000 | 33.6898901 | 41.43 |
X | 28/01/18 | 2704 | 33.6898901 | 42.04 |
X | 29/01/18 | 10716 | 33.6898901 | 40.29 |
X | 29/01/18 | 10716 | 33.6898901 | 42.39 |
X | 29/01/18 | 10716 | 33.6898901 | 40.12 |
X | 29/01/18 | 10716 | 33.6898901 | 41.74 |
X | 30/01/18 | 7128 | 33.6898901 | 39.71 |
X | 30/01/18 | 24948 | 33.6898901 | 40.85 |
Posted Date: