Calculate the monetary of the inventory, Cost Accounting

Assignment Help:

Learning Objective: After completing the project, the student will have gained familiarity, understanding and mastery of programming a realistic but simple application in Assembly Language:

a. Using Idea-Edit-Assemble-Execute-Debug cycle

b. Using the basic instructions from the x86 ISA: ADD, SUB, INC, DEC, MOV, CMP, JCond instructions, MUL, DIV,

Background, Scenario or Use Case:

The Use Case (Inventory Tracking) presented in Project 1 is extended in several directions.

Recall the Use Case:

Consider an enterprise (Idea Lifestyles, Inc.) with a single Retail Store. Ideal Lifestyles also has 5 separate Warehouses. The stock available for sale at the Retail Store is replenished on a periodic basis, (may be hourly, daily, weekly, biweekly, monthly, quarterly), by the transfer or transportation (freight or logistics) from each of the Warehouses. Each Warehouse-to-Store transfer consists of the shipment zero or more of units of the 5 distinct items that are sold by Ideal Lifestyles.

The purpose of the assembly program is to do Inventory Tracking, Monitoring and Management of the shipments received at the Retail Store, from the Warehouses, during each replenishment phase or run.

One can represent the shipment activity as follows:

From Warehouse 1:        Item(1,1)             Item(1,2)             Item(1,3)             Item(1, 4)            Item(1,5)

From Warehouse 2:        Item(2,1)             Item(2,2)             Item(2,3)             Item(2, 4)            Item(2,5)

From Warehouse 3:        Item(3,1)             Item(3,2)             Item(3,3)             Item(3, 4)            Item(3,5)

From Warehouse 4:        Item(4,1)             Item(4,2)             Item(4,3)             Item(4, 4)            Item(4,5)

From Warehouse 5:        Item(5,1)             Item(5,2)             Item(4,3)             Item(5, 4)            Item(5,5)

The entry Item(j, k) indicates that how many units of item type k were ship from Warehouse j to the Retail store.

Assume the available stock (Avail(j, k)) at each Warehouse (j), for each item type (k), before a particular replenishment shipment is given by:

At Warehouse 1:              Avail(1,1)             Avail(1,2)             Avail(1,3)             Avail(1, 4)            Avail(1,5)

At Warehouse 2:              Avail(2,1)             Avail(2,2)             Avail(2,3)             Avail(2, 4)            Avail(2,5)

At Warehouse 3:              Avail(3,1)             Avail(3,2)             Avail(3,3)             Avail(3, 4)            Avail(3,5)

At Warehouse 4:              Avail(4,1)             Avail(4,2)             Avail(4,3)             Avail(4, 4)            Avail(4,5)

At Warehouse 5:              Avail(5,1)             Avail(5,2)             Avail(4,3)             Avail(5, 4)            Avail(5,5)

For the new Project,

Assume the following unit prices are available to the item types sold by Ideal Lifestyles, Inc.:

Price(1)                                Price(2)                                Price(3)                                Price(4)                                Price(5)

Assume the following quantities of items are initially available at the Retail Store, BEFORE a particular set of shipments from the Warehouses:

InStore(1)           InStore(2)           InStore(3)           InStore(4)           InStore(5)

Project Description:

1.Compute how much the Inventory is worth:

a. Calculate the (monetary) of the inventory in the Retail Store before the next set of shipments arrive from the Warehouses.

b .Calculate the value of the stock transferred from each Warehouse to the Retail Store, for each item type.

c. Calculate the value of the stock, for each item type, remaining at each Warehouse, after there has been a shipment to the Retail Store.

d. Calculate the average value of each item type per warehouse, for a shipment scenario

2.Use the following decision tables to help the Ideal Lifestyles executives manage their enterprise:

a. Retail Store Decision Support. For each item type

Amount of Stock in Store BEFORE there is shipment from the Warehouses:

Amount <100 units                          "Order 10,000 units from all Warehouses"

Amount 100 - 1000 units               "Order 5000 units from all Warehouses"

Amount 1001 - 5000 units            "Order 1000 units from each Warehouse"

Amount 5001 - 10000 units          "Order 500 units from each Warehouse"

Amount > 10000 units                    "Decrease the unit price by 20%"

b.Warehouse Decision Support. For each item type

Amount of Stock remaining AFTER a shipment has gone from Warehouse to Retail Store:

Amount <100 units                          "DANGER: Inventory TOO LOW. Replenish: 5000 units"

Amount 100 - 1000 units               "DANGER: Inventory LOW. Replenish: 1000 units"

Amount 1001 - 5000 units            "Replenish: 500 units"

Amount 5001 - 10000 units          "Inventory Level ACCEPTABLE"

Amount > 10000 units                    "Decrease the unit price by 30%"

3. Write a "mini-report" to present your work, following a format such as the ff.

Title

Author

Affiliation

Date

Problem:

Solution Idea: place pseudo-code in the Appendix for the Idea

Design Implementation: place source code in the Appendix for the Implementation

Results: place screenshots in the Appendix

Discussion: touch on any aspect you think is significant and interesting

Summary and Conclusions

Acknowledgments: in anyone has helped you significantly

References: if any

Appendix

i.  Pseudo-code

ii. Source Code (make sure to include comments to document your intentions)

iii. Screen shots of Program execution, make sure to include results of appropriate Test Cases and Test Runs:

x. At least one Screen Dump of all the Registers at various stages in the code execution.

4. (Extra Credit): Extend your code to handle the following scenario.

Before each shipment (run), the Retail Store requests (demands) the amount of units of each item type to be shipped from each warehouse. If the amount of units requested for any item type is larger than the available stock at a warehouse, the warehouse ships all the units of that item type that it has on hand, but records or logs a negative number indicating the deficit that has to be backordered.

a. Compute the value of the shipment amounts based on shipment requests and available stock. Then compute the average per warehouse.

b. Compute the value of the stock remaining of each type remaining after shipment, based on shipment requests. Then compute the average per warehouse.

c. Make sure to include various Test Cases

 


Related Discussions:- Calculate the monetary of the inventory

Planning, what is planning and what part of this activity would you describ...

what is planning and what part of this activity would you describe as planning in the situasion above

DIVIDEND POLICY, EARNINGS AFTER TAX-1500000 NUMBER OF EQUITY SHARE OUTSTAND...

EARNINGS AFTER TAX-1500000 NUMBER OF EQUITY SHARE OUTSTANDING-300000 DIVIDEND PAID 600000 PRICE-EARNING RATIO-101 RATE OF RETURN ON INVESTMENT-20% WHAT IS OPTIMUM DIVIDEND PAY OUT

Explain how individual items of costs will be traced, Glaser Health Product...

Glaser Health Products of Ranier Falls, Georgia, is organized functionally into three divisions: Operations, Sales, and Administrative. Purchasing, receiving, materials and product

Compute cost, Your company completed the East Side subdivision. The costs a...

Your company completed the East Side subdivision. The costs are shown in Figure 11-4. The site concrete labor and outside lighting were done by subcontractors. The grading and exca

Marginal costing, MARGINAL COSTING As per the Chartered Institute of Ma...

MARGINAL COSTING As per the Chartered Institute of Management Accountants, London, the phrase 'Marginal cost' means - 'the amount at every given volume of output through which

Organize the accounting entries, JK is a motor dealership which organizes i...

JK is a motor dealership which organizes its financial statements to 30 November. In the year to 30 November 2009, transactions integrated the following: (a) JK had motor vehicl

Business management, Business Management Business Management includes ...

Business Management Business Management includes planning and staffing, organizing, directing and controlling an organization's activities so like to meet a specified objectiv

Sgtatement of Cash Flow, “The statement of cash flows is the easiest of the...

“The statement of cash flows is the easiest of the basic financial statements to prepare because you know the answer before you start. You compare the beginning and ending balances

Prepare the entry to assign factory labor to production, The gross earnings...

The gross earnings of the factory workers for Vargas Company during the month of January are $66,000. The employer's payroll taxes for the factory payroll are 8,000. The fringe ben

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd