Joan Zorba orders calculators for her office supply stores. Each calculator cost $35, currently she is ordering 230. Daily demand for these calculators is 5. The cost to re-order this item is estimated at $44, while the annual inventory holding cost is 22%. Orders are received two working days after an order is placed. The office operates 52 weeks per year, 5 days per week Determine the reorder point using EOQ. Greater than or equal to 43 and less than or equal to 49 Greater than or equal to 431 and less than or equal to 443 Greater than or equal to 2053 and less than or equal to 2064 Greater than or equal to 6 and less than or equal to 25

PLEASE MAKE IT IN EXCEL AND SHOW THE FORMULAS Comercial El Alacrán, S.A., purchases 200,000 units per year of the only product it sells. The cost of each order is $35.00. The annual unit maintenance cost is 23% of its cost of $8.00. The supplier currently takes 5.5 days to deliver, and the company sorts and stores it in 3 days. The company makes significant efforts to shorten these lead times. If it manages to reduce, through an agreement with the supplier, its delivery time to 3.5 days and to do the sorting in 1.5 days, how many units does the decrease in the reorder point amount to?

A book publishing company is planning its inventory. The cost to store one book is $4 per month. The cost for a production run is $8 per run and $0.50 per book. The company sells 3,600 books per month. How many should be in a production run to minimize inventory costs?

Determine the number ofsalespeople Wheels needs if it has 1,000 bicycle shopaccounts that need to be called on four times peryear. Each sales call lasts approximately 2.5 hours, andeach sales rep has approximately 1,250 hours per yearto devote to customers.

PLEASE MAKE IT IN EXCEL AND SHOW THE FORMULAS Comercial El Suspiro, S.A., purchases 2'100,000 units per year of a component. The cost of each order is $25.00. The annual unit maintenance cost is 27% of its cost of $2.00. On a 360-day basis, calculate the reorder point, knowing that it takes 10.5 days for the supplier to put in the LAB company the goods, and the company sorts and stores them in 1.5 days, calculate the reorder point.

Iguana, Inc., manufactures bamboo picture frames that sell for $30 each. Each frame requires 4 linear feet of bamboo, which costs $2.50 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $12 per hour. Iguana has the following inventory policies: Ending finished goods inventory should be 40 percent of next month’s sales. Ending direct materials inventory should be 30 percent of next month’s production. Expected unit sales (frames) for the upcoming months follow:      March 280 April 260 May 310 June 410 July 385 August 435   Variable manufacturing overhead is incurred at a rate of $0.40 per unit produced. Annual fixed manufacturing overhead is estimated to be $7,800 ($650 per month) for expected production of 3,000 units for the year. Selling and administrative expenses are estimated at $700 per month plus $0.50 per unit sold. Iguana, Inc., had $10,900 cash on hand on April 1. Of its sales, 80 percent is in cash. Of the credit…

Iguana, Inc., manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.50 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14 per hour. Iguana has the following inventory policies: • Ending finished goods inventory should be 40 percent of next month's sales. Ending direct materials inventory should be 30 percent of next month's production. Expected unit sales (frames) for the upcoming months follow: March April May June July August 315 330 380 480 455 505 Variable manufacturing overhead is incurred at a rate of $0.60 per unit produced. Annual fixed manufacturing overhead is estimated to be $7,200 ($600 per month) for expected production of 3,000 units for the year. Selling and administrative expenses are estimated at $650 per month plus $0.50 per unit sold. Iguana, Inc., had $11,000 cash on hand on April 1. Of its sales, 80 percent is in cash. Of the credit sales, 50 percent is…

Hello Company makes three different products. Due to the constraints of their manufacturing equipment and warehouse facility, the company is only able to produce, store, and sell a total of 50,000 units each month. The production of Products A and B varies each month; however, Product C is a special order for one customer who purchases the same number of units every month. Pete Davila, the CEO, has |provided the following data from last month for each product. Income Statement Product A Product B Product C Мax Cарacity 5,000 8.00 $ 2.00 $ Units 43,000 10.00 $ 3.00 $ 20,000 $ 2,000 50,000 Price per unit Variable expense per unit $ $ $ 50.00 15.00 $ 20.00 Total Fixed Costs 40,000 $ 10,000 Product Sales $ 430,000 $ 40,000 $ 100,000 $ 570,000 (169,000) 401,000 (70,000) 331,000 Variable Costs (129,000) (10,000) 30,000 $ (30,000) 70,000 $ Contribution Margin $ 301,000 $ Fixed Costs (20,000) 281,000 (40,000) (10,000) (10,000) 60,000 $ Operating income (loss) Required Using the Data Table…

Sacco Industries manufactures a popular interactive stuffed animal for children that requires three computer chips inside each toy. The company pays $2 for each computer chip. To help to guard against stockouts of the computer chip, Sacco Industries has a policy that states that the ending inventory of computer chips should be at least 25% of the following month's production needs. The production schedule for the first four months of the year is as follows: E (Click the icon to view the production schedule.) Requirement Prepare a direct materials budget for the first quarter that shows both the number of computer chips needed and the dollar amount of the purchases in the budget. ..... Prepare the direct materials budget by first calculating the total quantity needed, then complete the budget. Sacco Industries Direct Materials Budget - X For the Months of January through March Data table January February March Quarter Units to be produced 5,600 4,800 4,200 14,600 Stuffed animals to be…