50.1K

Verified Solution

Link Copied!

Use solver to find break-even sales

Use solver to find the sales level that will provide for a targeted net income of $200,000

Using the information for "Solver #3", determine the Economic Order Quantity (EOQ)

Home Insert Draw Page Layout Formulas Data Review View Tell me ra 4 Connections Properties Edit Links Stocks Get External Data Currencies Automatic Refresh All Geography Animals Anatomy c E23 A D E F G H I J K L M M 2 3 out of B Solver Add Solver to E4 Solver Result 1 Solver Result 2 Solver Result 3 Total 1 3 out of 5 6 7 out of out of 3 3 10 8 9 10 Solver #1 Use Solver to find Break-Even Sales 11 12 13 Solver #2 Use Solver to find the Sales level that will provide for a targeted net income of $200,000. 14 15 16 17 18 19 20 Warren Company Income Statement Year Ending 12/31/17 Break-Even TNI 21 22 23 Net Sales Less Variable Costs Contribution Margin Fixed Costs Operating Income Income Tax (Rate 30%) Net Income $1,514,371 1,029,772 $484,599 301,042 $183,557 55,067 $128,490 24 25 28 27 28 29 30 31 32 Solver #3 Using the information below, determine the Economic Order Quantity (EOQ). 33 34 35 36 37 38 39 Sales Ordering Cost Carry cost 2,000 units $25 per order $40 per unit 40 41 42 Total Carrying Costs = Average Inventory x Carrying Cost per Unit Average Inventory = 0/2 Total Carrying Costs - Q/2 XC 44 45 46 47 48 49 Total Ordering Costs = Number or Orders x Cost to make one order Number of orders = S/Q Total Ordering Costs = S/Q XO 50 51 EOQ Average Inventory Carrying Cost per unit Total Carrying Costs 110 52 53 54 55 50 Number of Orders Ordering Cost Total Ordering Costs 57 58 59 Total Costs 60 E4 Goal Seek Data Table Solver Pivot Table + Ready

Answer & Explanation Solved by verified expert

See Answer