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.

Terminator, Inc., manufactures a motorcycle part in lots of 250 units. The raw materials cost for the part is $150, and the value added in manufacturing 1 unit from its components is $280, for a total cost per completed unit of $430. The lead time to make the part is 3 weeks, and the annual demand is 4,200 units. Assume 50 working weeks per year. a. How many units of the part are held, on average, as cycle inventory? units. (Enter your response as an integer.) (Enter your response as an integer.) b. How many units of the part are held, on average, as pipeline inventory? What is its value? $ (Enter your response as an integer.) What is its value? $ units. (Enter your response as an integer.)

Novak Corp. began the year with 8 units of marine floats at a cost of $11 each. During the year, it made the following purchases: May 5, 34 unit at $16; July 16, 17 units at $21; and December 7, 22 units at $25. Assume there are 29 units on hand at the end of the period. Novak uses the periodic approach. What is the average cost of cost of good sold: $__

A retail has 8 stores supplied from 4 suppliers, where each supplier supplies different goods. Delivery from the Supplier is in trucks with a capacity of 50,000 units at a cost of $1100 per load plus $100 per delivery to the store. Inventory costs are $0.1 per unit per year. The Supply Chain Manager is considering whether to use direct shipping or Milk Run delivery for 4 stores for each truck in one shipment a) if annual sales in each store are 1000,000 units, which shipping method provides the lower cost b) if the annual sales in each store are 200,000 units, which shipping method provides the lower cost

Ibri Company, a manufacturer of stereo systems, started its production in January 2018. For the preceding 3 years had been a retailer of stereo systems. After a thorough survey of stereo system markets, Ibri Company decided to turn its retail store into a stereo equipment factory. Raw materials cost for a stereo system will total $77 per unit. Workers on the production lines are on average paid $11 per hour. A stereo system usually takes 4 hours to complete. In addition, the rent on the equipment used to assemble stereo systems amounts to $5,200 per month. Indirect materials cost $5 per system. A supervisor was hired to oversee production; her monthly salary is $3,000. Factory janitorial costs are $1,000 monthly. Advertising costs for the stereo system will be $5,000 per month. The factory building depreciation expense is $8,400 per year. Property taxes on the factory building will be $12,000 per year.  Instructions  Prepare an answer sheet with the following column headings. Cost…

Sandhill Traders is one of the largest RV dealers in Austin, Texas, and sells about 2,800 recreational vehicles a year. The cost of placing an order with Sandhill's supplier is $500, and the inventory carrying costs are $260 for each RV. Management likes to maintain safety stock of 12 RVs. Most of its sales are made in either the spring or the fall. How many orders should the firm place this year? (Round intermediate calculations to 1 decimal place, e.g. 15.5 and final answer to 0 decimal places, e.g. 15.)

Ceder Company has compiled the following data for the upcoming year:   Sales are expected to be 15,000 units at $55.00 each. Each unit requires 4 pounds of direct materials at $2.70 per pound. Each unit requires 1.5 hours of direct labor at $18.00 per hour. Manufacturing overhead is $3.70 per unit. Beginning direct materials inventory is $4,200.00. Ending direct materials inventory is $5,150.00. Selling and administrative costs totaled $136,920.   Required: 1. Determine Ceder's budgeted cost of goods sold. 2. Complete Ceder's budgeted income statement.

Shadee Corp. expects to sell 530 sun visors in May and 350 in June. Each visor sells for $25. Shadee’s beginning and ending finished goods inventories for May are 80 and 50 units, respectively. Ending finished goods inventory for June will be 60 units.   Each visor requires a total of $4.00 in direct materials that includes an adjustable closure that the company purchases from a supplier at a cost of $2.00 each. Shadee wants to have 34 closures on hand on May 1, 20 closures on May 31, and 23 closures on June 30. Additionally, Shadee’s fixed manufacturing overhead is $800 per month, and variable manufacturing overhead is $2.75 per unit produced. Each visor takes 0.70 direct labor hours to produce and Shadee pays its workers $9 per hour.   Additional information: Selling costs are expected to be 10 percent of sales. Fixed administrative expenses per month total $1,700.   Required: Determine Shadee's budgeted selling and administrative expenses for May and June. (Do not round your…

TimsTabletCo (TTC) produces tablet computers, and it must determine the number of units to be produced during each of the next four months. The following table gives the monthly demand and the monthly cost of producing each unit: Month 1 2 3 4 Demand (in units) 5000 2000 6000 1000 Production Cost (dollars per unit) 400 600 200 300 At the start, before Month 1, TTC has an inventory of 2000 units. Each month, up to 4000 units can be produced. TTC can use the units produced in a particular month in two ways: either use some units to satisfy the demand in the same month, or store some units in inventory for future use. The cost of storing units in inventory is $100 per unit per month. (a) Formulate an LP problem (P) to minimize the total cost of meeting the demands of the next four months. (b) Write the dual LP (D) of (P).

Hernandez, Inc. manufactures three models of picture frames for a total of 8,000 frames per year. The unit cost to produce a metal frame follows: $ 6 8. Direct materials Direct labor Variable overhead 2 Fixed overhead (70% unavoidable) Total $21 A local company has offered to supply Hernandez the 8,000 metal frames it needs for $17 each. Instructions Create an incremental analysis for the make-or-buy decision. Show your work. What should Hernandez decide?