Please help! especially part c,d,e.
part a answer:
Excel = Norm.Inv (0.889, 2500, 400)
= 2989
part b answer:
Excel = Norm.inv (0.95, 2500, 400)
= 3158
ASWER:
Given that,
a)
Underage cost, Cu = unit margin = $ 50
Overage cost, Co = Cost - selling price at 25% off the original retail price = $ 175 - 225*(1-25%) = $ 6.25
Critical ratio = Cu/(Cu+Co) = 50/(50+6.25) = 0.8889
z value = NORMSINV(0.8889) = 1.2206
Optimal quantity ABC should purchase = 2500+1.2206*400 = 2,988
b)
z value = NORMSINV(.95) = 1.6449
Optimal quantity ABC should purchase = 2500+1.6449*400 = 3,158
c)
For z = 1.6449, L(z) =NORMDIST(1.6449,0,1,FALSE)-1.6449*NORMSDIST(-1.6449) = 0.0209
Expected number of units short, L = L(z)*SD = 0.0209*400 = 8.36
d)
Expected Sales, S = 2500 - 8.36 = 2491.64
Expected inventory, V = Q - S = 3158 - 2491.64 = 666.36
Expected contribution to profit = S*Cu - V*Co
= 2491.64*50 - 666.36*6.25
= $ 120,417.25
e)
For ordering policy in part b to be optimal,
Cu/(Cu+Co) = 0.95
Substituting Co = 118.75, in the above equation, and solving for Cu, we get
Cu = 0.95*6.25/(1-0.95)
= $ 118.75
Additional cost per unit out of stock, = 118.75-50
= $ 68.75
Please help! especially part c,d,e. part a answer: Excel = Norm.Inv (0.889, 2500, 400) = 2989 part b answer: Excel = Norm.inv (0.95, 2500, 400) =...
Please help! especially part c,d,e. I have found the answer for part a and b, so please help me part c,d, and especially part e! part a answer: Excel = Norm.Inv (0.889, 2500, 400) = 2989 part b answer: Excel = Norm.inv (0.95, 2500, 400) = 3158 ABC Sportswear company designs and sells wetsuits to the U.S. market. The designs of the wetsuits are updated each year. The process for updating the design typically starts in January the year before...
especially for 5。6。7 。the most important Part B: Comprehensive Master Budget Allenby's CEO decided to apply the new budget approach in preparing comprehensive budgets for the upcoming second quarter. The following information is assembled from accounting and other business areas. The company sells many styles of earrings, but all are sold for the same price, i.e. $12 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of...
Please answer part a, b, c, and d. JJim's Mulch Co. buys mulch and resells it directly to consumers. Due to the nature of their inventory, they employ the last-in first-out (LIFO) method. At the beginning of the year, Jim's Mulch Co. had 62 bags of mulch which had been purchased at $2 per bag. In April. Jim's Mulch Co. bought 50 bags for $5 per bag. In September, Jim's Mulch Co. sold 82 bags of mulch for $12 per...
please help with questions 1 - 6. Thanks M N O B C D E G H KL Your task is to make an estimate of McCormick & Company's weighted Average cost of Capital (WACC) to use as the discount rate for evaluating capital projects. Interest rates have risen and the CFO plans to borrow $350 million using the 20 year bond that you recommended in Project 4. For most of the past 10 years the company has used 7%...
Help needed please. Thumbs up in advance! Problem 5-05A a, bl-b3, c-e (Part Level Submission) (Video) The trial balance of Concord Corporation contained the following accounts at November 30, the end of the company's fiscal year. Concord Corporation Trial Balance November 30, 2020 Credit Debit $8,200 31,100 43,600 6,000 135,000 $ 30,000 55,000 35,200 55,000 40,000 Cash Accounts Receivable Inventory Supplies Equipment Accumulated Depreciation ---Equipment Notes Payable Accounts Payable Common Stock Retained Earnings Dividends Sales Revenue Sales Returns and Allowances...
I need help on part B (C-F) please. I will rate the question if I get it wrong or right on my homework. MINICASE Scandi Home Furnishings, Inc. high grade plastics Kaj Rasmussen founded Scandi Home Furnishings as a corporation during mid 2013. Sales during the first full year (2018) of operation reached $1.3 million Sales increased by 15 percent in 2015 and another 20 percent in 2016. However, after increasing in 2015 over 2014, profits fall sharply in 2016,...
answer part d please I posted parts a, b and c as seprate questions. Radford River Resort opened for business on June 1 with 10 deluxe villas. Its trial balance before adjustment on August 31 is as follows. RADFORD RIVER RESORT Trial Balance August 31, 2020 Account Number Debit Credit 101 Cash $ 19,600 126 Supplies 3,300 130 Prepaid Insurance 6,000 140 Land 25,000 141 Buildings 125,000 149 Equipment 26,000 201 Accounts Payable $ 6,500 208 Unearned Rent Revenue 7,400...
Please use the above info to answer the next problems B C D 1 Due to its popularity, the Black and White Handbag (BW14293) is normally a stock item. However, the 2 handbag is currently out of stock. Rather than producing only enough units to fill Katie's order, 3 management would like to produce a job (Job 114) that is large enough to fill Katie's order and replenish 4 stock. The fabric used for this job can be stacked four...
Need help with comprehensive project (PLEASE MAKE SURE CHECK TOTALS ARE CORRECT) TIA!!! T- Accounts Adjusted Trial Balance Income Statement Statement of Retained Earnings Balance Sheet Closing Entries Post-closing trial balance Read ALL instructions before getting started! ABC Corporation is a new company that buys and sells office supplies. Business began on January 1, 2016. Given on the first two tabs are ABC's 12/31/16 Unadjusted Trial Balance and a list of needed adjustments. 1. Make all 12 adjustments on the...
AND THE USE OF CALCULATORS SPREADSHEETS 2. PLEASE MAKE SURE TO WRITE Sttolal ANSWER EXPLANATIONS THAT ARE SUPPORTED BY YOUR CALCULATIONS WHEN ASKED IN A GINEN QUESTION 3. PLEASE USE EXCEL TO CALCULATE AND SHow WORKINGS. THANKS. 2 Industrial Grinders AWN 4 During the term, we had a case study, Industrial Grinders, which focused on Sunk and Opportunity Costs. 6 Please refer to the table below, which comes from data in the Industrial Grinders case Industrial Grinders 100 Steel Rings...