An inventory applycation calls for the weekly updating

Assignment Help Operation Management

Reference no: EM131228836

An inventory applycation calls for the weekly updating, or posting, of the merchandise inventory master file from the purchases transaction file and the sale transaction file. This updating process is performed every Friday just before the close of business. Sales of Item No. #12345 are stable at a rate of 5 units a day, 5 days a week. Purchases are made every 3 weeks in quantities of 75 units, and the purchased goods are received first thing Monday morning. On Friday evening, January 28, the inventory level of item No. 12345 in the warehouse is 10 nunits, and the balance for the item in the inventory master file was verified as being correct. The receipt of purchased goods was scheduled for the following Monday. Required: Perform a simulation for the month of February to determine the maximum discrepancy between the actual quantity of item No. 12345 on hand and the balance shown in the inventory master file. (Set up table with a line for each day in the month and calculate the quantity on hand corresponding to the stated pattern of purchases and sales. Also calculate the net transaction activity used to update the inventory master file on each updating date and the resulting balance in the inventory master file.)

Reference no: EM131228836

Questions Cloud

Write arguing the importance of your chosen subjects : Make an initial posting concerning three important events prior to 1776 that you believe influenced the course of events in this nation (United States). Write 3 paragraphs arguing the importance of your chosen subjects.

Planning and implementation of an organizational change : (a) For organizational change to be successful, what role should a leader take in vision development? (b) How would you weave proactive and reactive elements into the planning and implementation of an organizational change effort?

Utilization review and access : As utilization review techniques are implemented by MCOs, how has this had an impact on patients being able to access the care they need?

Analyze how and where revenues are derived for the agency : Analyze how and where revenues are derived for the agency. Analyze which revenues are used in which funds: governmental, proprietary, and fiduciary.

An inventory applycation calls for the weekly updating : An inventory applycation calls for the weekly updating, or posting, of the merchandise inventory master file from the purchases transaction file and the sale transaction file. This updating process is performed every Friday just before the close of b..

Create an effective personal brand : Write a 1500 words report on how to create an effective personal brand and highlight the action plan of what you will do to create an effective personal brand.

People struggle with humility : Let's discuss humility. We often find that people struggle with humility. When I think of humility, I tend to think of the attributes such as putting personal importance on a lower scale of importance and significance than another

How do you explain the relatively rapid rise : How do you explain the relatively rapid rise and expansion of Islam from its Arabian craddle to territories thus far dominated by powerful states and cultures throughout Asia, North Africa, and Southern Europe?

Project management course : Please describe each of these methods: The Simple Payback Method and Discounted Cash Flow as they are described in the associated case studies. Please use any charts or graphs that you think may be helpful in answering these questions.

User Account

All Pages