Develop your own worksheet for the Butler inventory simulation model shown in Figure. Suppose that management prefers
Question:
FIGURE EXCEL WORKSHEET FOR THE BUTLER INVENTORYPROBLEM
Transcribed Image Text:
PortaCom Risk Analysis Lil 3 Sel ling Price per Unit 4 Administrative Cost $249 5400,000 600,000 5 Advertising Cost 7 Direct Labor Cost wer Parts Cost (Uniform Distribution) $80 S100 Upper Smallest Value 9Random No. Random No. Cost per Unit Largest Value 0.0 12 13 14 15 0.3 0.7 0.9 $43 $44 $45 $46 $47 0.7 0.9 Demand (Normal Distribution) Mean Std Deviation 15000 4500 17 Simulation Trials 18 Direct Labor Parts Cost per Unit $85.36 91.68 93.35 $98.56 $88.36 First-Year Demand 17.366 12,900 20,686 0.888 14,259 20 21 Trial Cost per Un Profit 1,025,570 $461.828 $1.288,906 24 648,911 ($71.739) S1,110952 $703.118 45 516 517 18 519 520 521 496 497 498 499 $94.38 $90.85 90.37 92.50 19.257 14,920 13.471 18,614 43 1,056.847 523 524 525 526 527 Summary Statistics Mean Profit Standard Deviation Minimum Profit Maximum Profit Number of Losses Probability of Loss $698.457 ($785,234) $2.367.058
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 61% (13 reviews)
Butler Inventory simulation spreadsheet The shortage cost has been ...View the full answer
Answered By
Asim farooq
I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening.
My Expert Service
Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities
4.40+
65+ Reviews
86+ Question Solved
Related Book For
Quantitative Methods for Business
ISBN: 978-0324651751
11th Edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam
Question Posted:
Students also viewed these Statistics questions
-
Develop your own worksheet for the PortaCom simulation model described in Section 161 a Compute the mean profit the minimum profit and the maximum profit b What is your estimate of the probability of...
-
The vehicle model shown in Figure 13.4.2(a) has the following parameter values: weight = 4800 lb, 1G = 1800 slug-ft2, L1 = 3.5 ft, and L2 = 2.5 ft. Design the front and rear suspension stiffnesses to...
-
Consider the first-order SDM model shown in figure(a) Show that the quantization noise power in the signal hand {-B, B} is given by:(b) Using a two-term Taylor series expansion of the sine function...
-
Find the point on the plane z = x + y + 1 closest to the point P = (1, 0, 0). Minimize the square of the distance.
-
Assume that you are employed in technical sales in powder-metallurgy products. What applications currently using non-P/M parts would you try to develop? What would you advise your potential customers...
-
For the Darlington network of Fig. 5.181: Fig. 5.181 a. Determine the dc levels of V B1 , V C1 , V E2 , V CB1 , and V CE2 . b. Find the currents I B1 , I B2 , and I E2 . c. Calculate Z i and Z o . d....
-
Donald Winn and Judy Reed agreed to liquidate their partnership on June 30 of the current year. On that date, after financial statements were prepared and closing entries were posted, the general...
-
Costanza Company experienced the following events and transactions during July. July 1 Received $3,000 cash in advance of performing work for Vivian Solana. 6 Received $7,500 cash in advance of...
-
1)Suppose one random sample of 256 letters contained 24 "e"s. What is the approximate value for the proportion of "e"s in this sample? 0.09 10.67 0.31 30.72 2)Is the proportion of "e"s calculated for...
-
McDonalds is the worlds leading hamburger fast-food chain, with over 32,000 restaurants in 118 countries. More than 75 percent of McDonalds restaurants are owned and operated by franchisees, which...
-
A building contractor is preparing a bid on a new construction project. Two other contractors will be submitting bids for the same project. Based on past bidding practices, bids from the other...
-
In preparing for the upcoming holiday season, Mandrell Toy Company designed a new doll called Freddy. The fixed cost to produce the doll is $100,000. The variable cost, which includes material,...
-
Three groups of students from the Geotechnical Engineering class collected soil-aggregate samples for laboratory testing from a recycled aggregate processing plant in Palm Beach County, Florida....
-
Journalize the following transactions using the direct write-off method of accounting for uncollectible receivables. Apr. 1 Sold merchandise on account to Jim Dobbs, $7,200. The cost of the...
-
The four primary methods of gaining a competitive advantage are cost leadership, differentiation, defensive strategies and strategic alliances. Write detailed short notes on any two of these...
-
How does the concept of the circular economy propose a shift from traditional linear models of production and consumption, and what are the key strategies to achieve this transition at an industrial...
-
Explain the Product lifecycle in full detail and provide examples from the assigned company for each stage of the product lifecycle.
-
Boys get more attention in the classroom than girls. There's no doubt about it. Reams of studies show that teachers, from preschool to grade school, interact more with males than females. Especially...
-
What is the amount of the ownership interest at the end of Day 2? (a) 17,800 (b) 22,000 (c) 27,000 (d) 29,800 The following information about Day 2, together with the previous information about Day...
-
Read the case study Richter: Information Technology at Hungarys Largest Pharma and answer the following question: How does the organization ensure the accuracy of the data it stores?
-
Using the formulation and boundary condition results of the thin notch crack problem shown in Fig. 8.29, explicitly develop the stress components given by relations (8.4.56) and (8.4.57). Fig 8.29...
-
Manning Autos operates an automotive service. To complete their repair work, Manning mechanics often need to retrieve parts from the company's parts department counter. Mechanics arrive at the parts...
-
Develop your own waiting line simulation model for the Black Sheep Scarves problem described in Section 12.3. Assume that a quality inspection department for a new production facility is expected to...
-
The Burger Dome waiting line model in Section 11.1 studies the waiting time of customers at its fast-food restaurant. Burger Dome's single-server waiting line system has an arrival rate of 0.75...
-
Consider the following two mutually exclusive projects: YearCash Flow (A)Cash Flow (B)0-$187,224-$15,025126,0004,942251,0008,047357,00013,4694388,0008,545Whichever project you choose, if any, you...
-
ACCTG 3 3 0 Guthrie s Golden Fried Chicken Fingers Franchise * Guthrie s restaurant was started in 1 9 6 5 in Haleyville, Alabama, by Hal Guthrie. The restaurant began serving Chicken Fingers in 1 9...
-
Suppose you buy an electronic device that you operate continuously. The device costs you $300 and carries a one-year warranty. The warranty states that if the device fails during its first year of...
Study smarter with the SolutionInn App