The senior buyer at How Does Your Garden Grow Inc. needs to select a supplier for plastic patio chairs for a one-year contract. The chairs will be shipped to the company's distribution center in Toledo, Ohio. Three potential suppliers have been identified and the data were gathered. Company Annual sales Plant location Purchase price per unit Quality (defective parts per million) Delivery (% on time) Transportation time ABC Molding $9 million Erie, PA $8.40 280 ppm Supplier Assecament Scores Category Quality performance and systems Management capabilities and attitudes Delivery performance Purchase price Total Weighted Score 98.5% 1 day *Shipping is not included. DolctureClick here for the Excel Data Eile a. Complete the weighted-point model. (Round your answers to 1 decimal place.) ABC Molding Weight Rating 50% 10% 20% 20% 3 3 Perfection Plastics $73 million Oakland, CA $10.55 64 ppm 4 5 90% 5 days Score Perfection Plastics Rating 5 4 2 2 -Products $34 million St. Louis, MO $11.45 123 ppm 95% 2 days I-Products Score Rating Score 3 1 3 2

i need the answer quickly

Owe

please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)

SixthZ currently produces and sells 1,200 treehouses per year and sells them at $1200 per treehouse. SixthZ has the capacity to produce 1,400 treehouses. SixthZ has received a special order from the families in Davis's Village Homes community. They would like to buy 135 treehouses at a price of $800 per treehouse. The product unit cost for the treehouses is shown below: Direct Materials $500 Direct Labor $300 Variable Overhead $40 Fixed Overhead $100 SixthZ incurs no variable selling and administrative expenses. Should SixthZ accept the special order? O No, because accepting the order would result in a $113,400 decrease in operating income O No, because accepting the order would result in a $18,900 decrease in operating income O Yes, because accepting the order would result in a $54,000 increase in operating income O No, because accepting the order would result in a $5,400 decrease in operating income

Crede Inc. has two divisions. Division A makes and sells student desks. Division B manufactures and sells reading lamps. Each desk has a reading lamp as one of its components. Division A can purchase reading lamps at a cost of $10.10 from an outside vendor. Division A needs 11,100 lamps for the coming year. Division B has the capacity to manufacture 49,600 lamps annually. Sales to outside customers are estimated at 38,500 lamps for the next year. Reading lamps are sold at $12.09 each. Variable costs are $6.87 per lamp and include $1.41 of variable sales costs that are not incurred if lamps are sold internally to Division A. The total amount of fixed costs for Division B is $75,900. Consider the following independent situations. What should be the minimum transfer price accepted by Division B for the 11,100 lamps and the maximum transfer price paid by Division A? (Round answers to 2 decimal places, e.g. 15.25.) Per unit Minimum transfer price accepted by Division B $_ Maximum transfer…

Willis Company is trying to decide which of two bicycle wheels to manufacture next quarter. Cost data pertaining to the two choices follow. Multiple Choice Cost of materials per unit Cost of direct labor per unit Advertising cost per year 4,000 Depreciation on equipment 6,000 Which costs are relevant to the decision of which wheel to produce? Cost of materials and direct labor Wheel A $25 30 Cost of direct labor, advertising, and depreciation Cost of materials, direct labor and advertising Cost of advertising and depreciation Wheel XZ $45 35 7,000 9,000

Determining the Optimal Product Mix with One Constrained Resource Casual Essentials, Inc. manufactures two types of team shirts, the Homerun and the Goalpost, with unit contribution margins of $11 and $15, respectively. Regardless of type, each team shirts must be fed through a stitching machine to affix the appropriate team logo. The firm leases seven machines that each provides 1,000 hours of machine time per year. Each Homerun shirt requires 6 minutes of machine time, and each Goalpost shirt requires 30 minutes of machine time. Assume that there are no other constraints. Required: If required, round your answers to the nearest whole number. If an amount is zero, enter "0". 1.  What is the contribution margin per hour of machine time for each type of team shirts?   Contribution Margin Homerun $fill in the blank 1 Goalpost $fill in the blank 2 2.  What is the optimal mix of team shirts?   Optimal Mix Homerun fill in the blank 3 units Goalpost fill in the blank 4 units…

A-2

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.