US or in Canada. Show your work. (6 pts.) a) First, consider making the lightbulbs in the US. Briter estimates that the largest cost will be for materials at seventy-five cents per bulb, with labor costs totaling fifty cents per bulb. They estimate that overhead costs are 50% of the direct labor costs. They also project an annual fixed cost of $60,000. What is the total cost per bulb for making these in the US? Cost per bulb = (8 pts.) b) Now, consider making these lightbulbs in Canada. Briter estimates that this will incur direct labor costs of forty cents per bulb and direct materials costs of fifty cents per bulb. They estimate that I overhead costs are 50% of the direct labor costs. With manufacturing in Canada, they project a smaller annual fixed cost (due to lower land costs) of $45,000. There would also be inventory costs that total ten cents per bulb. In addition, there is a tariff to be paid that is a percentage of the sum of direct labor and direct materials costs. How large can the tariff be (as a percentage) so that the total cost per bulb is $1.85 ? Tariff (%)= points total) A manufacturer produces goods at five US cities, from which the goods are sent to seven major customers in the following cities: Flint, Houston, Jackson, Kent, Lakeland, Mrami, and Oakdale. The monthly production of the goods is shown in the table below: The monthly demands for each customer (in tons) are shown below. The shipping costs per ton of product from the manufacturers to the customers are shown in the table below. a) Solve a Transportation Problem in Excel to find the lowest cost delivery plan to meet the customers' requirements. (i) Report the minumum cost from your solution. (ii) Insert (paste) below the Excel spreadsheet that you used showing the optimal solution (include all rows and columns of the spreadsheet) (i) Minimum cost (ii) - - Paste Your Excel Spreadsheet Here - - b) How much does Boston send to each destination? c) From which manufacturing cities does Lakeland receive shipments - and how many tons are sent from each? US or in Canada. Show your work. (6 pts.) a) First, consider making the lightbulbs in the US. Briter estimates that the largest cost will be for materials at seventy-five cents per bulb, with labor costs totaling fifty cents per bulb. They estimate that overhead costs are 50% of the direct labor costs. They also project an annual fixed cost of $60,000. What is the total cost per bulb for making these in the US? Cost per bulb = (8 pts.) b) Now, consider making these lightbulbs in Canada. Briter estimates that this will incur direct labor costs of forty cents per bulb and direct materials costs of fifty cents per bulb. They estimate that I overhead costs are 50% of the direct labor costs. With manufacturing in Canada, they project a smaller annual fixed cost (due to lower land costs) of $45,000. There would also be inventory costs that total ten cents per bulb. In addition, there is a tariff to be paid that is a percentage of the sum of direct labor and direct materials costs. How large can the tariff be (as a percentage) so that the total cost per bulb is $1.85 ? Tariff (%)= points total) A manufacturer produces goods at five US cities, from which the goods are sent to seven major customers in the following cities: Flint, Houston, Jackson, Kent, Lakeland, Mrami, and Oakdale. The monthly production of the goods is shown in the table below: The monthly demands for each customer (in tons) are shown below. The shipping costs per ton of product from the manufacturers to the customers are shown in the table below. a) Solve a Transportation Problem in Excel to find the lowest cost delivery plan to meet the customers' requirements. (i) Report the minumum cost from your solution. (ii) Insert (paste) below the Excel spreadsheet that you used showing the optimal solution (include all rows and columns of the spreadsheet) (i) Minimum cost (ii) - - Paste Your Excel Spreadsheet Here - - b) How much does Boston send to each destination? c) From which manufacturing cities does Lakeland receive shipments - and how many tons are sent from each