please use excel if u can :)

Case 8-46 a-f, g1-g2 Big Sports Manufacturing produces basketballs used for indoor and outdoor games. The company has had significant troubles over the past few years, as the number of competitors in the basketball market has increased dramatically. Recently, the company was forced to cut back production in order to decrease its rising inventory level. The following is a list of costs for the company in 2020: $2.75 1.40 5.60 0.50 0.15 Variable costs per unit Rubber Other materials-indirect Ball makers-direct labour Factory electricity usage Factory water usage Other labour-indirect Selling and administrative expenses Fixed costs per year Factory property taxes Factory sewer usage Factory electricity usage Selling and adminis ive expenses 0.27 0.40 $120,000 50,000 40,000 83,000 Big Sports Manufacturing had an ending inventory of 85,000 basketballs in 2019. For these units, the fixed manufacturing overhead cost was $4.00 per unit and variable manufacturing costs were $9.67 per unit. In 2020, the company produced 35,000 basketballs, sold 72,500 basketballs, and had an ending inventory of 47,500 basketballs. The basketballs sold for $18 each. Big Sports uses the FIFO method. Calculate Big Sports' manufacturing cost per unit under a variable-costing system. (Round answer to 2 decimal places, e.g. 15.25.) per unit Manufacturing cost Prepare a variable-costing income statement for 2020. BIG SPORTS MANUFACTURING Variable-Costing Income Statement Sales in units $ $ Calculate the manufacturing cost per unit under a throughput-costing system. (Round answer to 2 decimal places, e.g. 15.25.) Calculate the manufacturing cost per unit under a throughput-costing system. (Round answer to 2 decimal places, e.g. 15.25.) per unit Manufacturing cost $ Prepare a throughput-costing income statement for 2020. Assume that increased costs in 2020 are related to variable costs other than materials. BIG SPORTS MANUFACTURING Throughput Costing-Income Statement Sales in units $ $ Calculate Big Sports' manufacturing cost per unit under absorption costing. (Round answer to 2 decimal places, e.g. 15.25.) 2019 2020 Manufacturing cost $ per unit $ Prepare an absorption-costing income statement for 2020. per unit Prepare an absorption-costing income statement for 2020. BIG SPORTS MANUFACTURING Absorption-Costing Income Statement Sales in units $ $ Big Sports' chief financial officer, Mr. Swetkowski, is contemplating the benefits of using the absorption-costing and variable-costing approaches. He has asked you to perform a variety of tasks to help him analyze the differences between the two approaches: 1. Reconcile the differences between the income values of the two approaches. Reconciliation of net income Variable-costing net income $ FMOH deferred in ending inventory FMOH released from beginning inventory Absorption-costing net income $ 2. Mr. Swetkowski has heard that some basic managerial tasks can be better performed when variable costing is used. Calculate the break-even point in units for the company in 2020 using the variable-costing data. (Round answer to 0 decimal places, e.g. 5,275.) Break-even point units