Reference no: EM13944210
You must show your work at arriving at the answers to receive credit. Do so using EXCEL and by submitting this assignment on an EXCEL spreadsheet and attaching the .xlsx file
Put your name, the assignment name (Unit 2 Assignment) and the date submitted at the top.
Separate and number your response to each question so they can be clearly identified.
5.1 bell technologies stocks and sells its own brand of laptop computers. it costs the firm $543 each time it places an order with the manufacturer for laptops the cost carrying one laptop in inventory for a year is $210. the store manager estimates that total annual demand for the computers will be 1,800 units with a constant demand rate throughout the year. Bell's policy is never to have stock outs of the store-brand laptop. the store is open for business seven days per week from 9 a.m to 6 p.m. Determine the following:
a. Optimal order quantity per order
b. minimum total annual inventory costs
c. The number of orders per year
d. the time between orders (in working days)
5.4 Mitch's body shop uses a high flammable solvent. it must have the product delivered by special cargo trucks designed for the safe shipment of chemicals. the delivery cost for the solvent is $1,200 each time an order is placed. The solvent is packaged in one-gallon plastics containers. the cost of holding the chemical in storage is $120 per gallon per year. the annual demand for the chemical, which is constant over time, is 1,783 gallons per year. the lead time from the time of order placement until receipt is 14 days. The company operates 250 working days per year. compute the optimal order, quantity, total minimum inventory cost, and reorder point.
5.6 The Apple Valley company makes apple butter to supply to local street vendors in Monterey, California. Apple Valley can make 330 pounds of apple butter per day and demand from the street vendors is 190 pounds per day. Each time Apple Valley makes apple butter, it costs $176 to set up the production process. The annual cost of carrying a pound of apples in a refrigerated storage area is $6.50. Determine the optimal order size and the minimum total annual inventory cost.
5.15 the following table contains figures on the annual volume and unit costs for a random sample of 10 items from a list of 2,000 inventory items at a health care facility. Please develop an ABC analysis for these items. Also, draw an ABC diagram reflecting your results. How could the purchasing manager use this information?
Item Annual Usage Unit Cost
1 2,400 $19.51
2 6,200 32.60
3 8,500 10.20
4 3,200 6.80
5 6,000 4.50
6 750 55.70
7 8,200 3.60
8 9,000 44.90
9 5,800 35.62
10 820 82.60
5.16 The purchasing manger for Omni Enterprises requested the following data from the accounting department:
Annual demand -$15,500
Cost of placing an order =$180
Annual inventory holding costs = 20 percent
Unit cost =$75
a. please calculate the following:
i. The optimal order quantity
ii. the average number of orders
iii. the total annual inventory costs.
b. Suppose the Omni has been arbitrarily ordering 50 times per year. What is the total annual inventory cost?
c. Assume that Omni incorrectly estimates the order cost to be $250 per order. What order quantity will Omni use? What actual inventory costs will be incurred?
Confidence interval of mean annual salary of graduates
: If the dean wanted a 90% confidence interval of mean annual salary of graduates with width no more than $3,000, how large a sample of graduates would she need?
|
Dew point of a mixture of hydrocarbons
: At a pressure of 10 bar, determine the bubble and dew point of a mixture of hydrocarbons, composition, mol%: n-butane 21, n-pentane 48, n-hexane 31. The equilibrium K factors can be estimated using the De Priester charts in Dadyburjor (1978) or fo..
|
What is the primary focus of requirements analysis
: What is the primary focus of requirements analysis? What is not the focus? How should each pro-posed requirement be evaluated? What critical error must be avoided
|
Identify the relevant costs in a make-or-buy decision
: What factors must mangement Consider when deciding wnethor to continue using an asset, repair, or replace it? Identify the relevant costs in a make-or-buy decision and provide an example of each type of cost.
|
Arriving at the answers to receive credit
: You must show your work at arriving at the answers to receive credit. Do so using EXCEL and by submitting this assignment on an EXCEL spreadsheet and attaching the .xlsx file Put your name, the assignment name (Unit 2 Assignment) and the date submitt..
|
Evaluate the importance of research and statistics
: Evaluate the importance of research and statistics in making business and industry decisions - calculate and analyze descriptive and inferential statistics during the decision making process using popular software packages.
|
Find the shortest paths from s to all the other nodes
: Find the Minimum-Cost Spanning Trees for the above graph using the following algorithms.
|
Documents reflecting on corporate governance
: Discuss how these two documents reflect on corporate governance and transparency at these institutions (note that the code of ethics for professional accountants only applies to members of certain accounting associations).
|
Percentage of all shipments can be expected
: If the total weight of the two bags, X1 + X2 exceeds 105.4 pounds, a surcharge is added onto the shipping cost. What percentage of all shipments can be expected to result in a surcharge being added to the shipping cost?
|