Question

Bambino Sporting Goods makes baseball gloves that are very popular in the spring and early summer season. Units sold are anticipated as follows: Monthly Unit Sales March April May June 3,900 7,900 12,800 10,800 35,400 Total units sold If seasonal production is used, it is assumed that inventory will directly match sales for each month and there will be no inventory buildup. The production manager thinks the preceding assumption is too optimistic and decides to go with level production to avoid being out of merchandise. He will produce the 35,400 units over four months at a level of 8,850 per month. a. What is the ending inventory at the end of each month? Compare the unit sales to the units produced and keep a running total. Ending Inventory March April May June 4,950 units 5,900 units 1,950 units 0 units 30
B is incorrect please help!!

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

WORKING CAPITAL APPROACH - Microsoft Excel (Product Activation Failed) Review View Add-Ins Formulas Data - 2x 11 A = = = V General A A Wrap Text FMerce Merge & Center Center Σ AutoSum : A Fill 2 Sort & m Find & E E E s 4.0 .00 8.9 Insert Delete Format $ - % % Number Conditional Format Formatting as Table Styles Cell Styles Clear Filter Editing Select Alignment Cells File Home Insert Page Layout % Cut Calibri Ea Copy Paste Format Painter B I U - D Clipboard Font DM35 Fax DE 21 22 DG DH DI DJ DK DL DM DN UNITS MONTH SOLD 23 24 25 26 MARCH APRIL MAY JUNE UNITS CHANGE IN ENDING PRODUCED INVENTORY INVENTORY C=B-A 3900 8850 4950 4950 [4950] 7900 8850 950 5900 [4950 + 950] 12800 8850 -3950 1950 [5900 - 3950] 10800 8850 -1950 0 (1950-1950] 27 28 29 30 31 32 33 MONTH A ENDING TOTAL COST INVENTORY INVENTORY 16 PER UNIT FINANCING COST (0.5% PER MONTH) B = A*16 C=B*0.5% 4950 79200 396 5900 94400 1950 31200 156 34 472 35 36 37 38 39 MARCH APRIL MAY JUNE TOTAL FINANCING COST = 1024 Z SCORE Sheet1 Sheet2 ferences insu pv fv cash opti LINE OF CREDIT eoq, miller CARD BANKER ACCEPTANC FACTOR SI DISC FOCAL WC REQUIRE Rea 0 201 130% * 6. B 9 ENG 08-08-2019