Question

In: Finance

Product Unit cost Cost Price Date Product Unit Sales (report 2 numbers after decimal place) A1...

Product Unit cost Cost Price Date Product Unit Sales (report 2 numbers after decimal place)
A1 56 61.6 1/1/2010 A2 3 Question 3 What is the total cost of good sold in 1/2/2010
A2 16 17.6 1/1/2010 A3 6
A3 90 99 1/1/2010 A22 5
A4 67 73.7 1/1/2010 A52 32 Question 4 What is the total sales in 1/3/2010
A5 29 31.9 1/1/2010 A7 60
A6 11 12.1 1/1/2010 A18 98
A7 5 5.5 1/1/2010 A32 96 Question 5 What is the total profit for the whole period
A8 57 62.7 1/2/2010 A23 97
A9 14 15.4 1/2/2010 A91 52
A10 45 49.5 1/2/2010 A81 63
A11 34 37.4 1/2/2010 A7 98
A12 44 48.4 1/2/2010 A10 52
A13 57 62.7 1/2/2010 A53 22
A14 71 78.1 1/2/2010 A77 11
A15 33 36.3 1/2/2010 A95 23
A16 41 45.1 1/3/2010 A7 325
A17 37 40.7 1/3/2010 A10 45
A18 52 57.2 1/3/2010 A33 74
A19 4 4.4 1/3/2010 A24 52
A20 33 36.3 1/3/2010 A91 20
A21 39 42.9 1/3/2010 A60 10
A22 8 8.8 1/3/2010 A75 10
A23 89 97.9 1/3/2010 A85 120
A24 3 3.3 1/4/2010 A24 100
A25 7 7.7 1/4/2010 A3 150
A26 60 66 1/4/2010 A10 130
A27 31 34.1 1/4/2010 A11 55
A28 43 47.3 1/4/2010 A65 69
A29 23 25.3 1/4/2010 A51 95
A30 68 74.8
A31 20 22
A32 35 38.5
A33 77 84.7
A34 35 38.5
A35 75 82.5
A36 22 24.2
A37 9 9.9
A38 9 9.9
A39 19 20.9
A40 29 31.9
A41 43 47.3
A42 58 63.8
A43 60 66
A44 62 68.2
A45 48 52.8
A46 56 61.6
A47 54 59.4
A48 68 74.8
A49 6 6.6
A50 2 2.2
A51 82 90.2
A52 13 14.3
A53 20 22
A54 44 48.4
A55 20 22
A56 64 70.4
A57 97 106.7
A58 87 95.7
A59 8 8.8
A60 33 36.3
A61 84 92.4
A62 77 84.7
A63 85 93.5
A64 23 25.3
A65 23 25.3
A66 39 42.9
A67 40 44
A68 94 103.4
A69 11 12.1
A70 44 48.4
A71 88 96.8
A72 39 42.9
A73 45 49.5
A74 24 26.4
A75 72 79.2
A76 13 14.3
A77 96 105.6
A78 42 46.2
A79 82 90.2
A80 37 40.7
A81 7 7.7
A82 92 101.2
A83 14 15.4
A84 18 19.8
A85 92 101.2
A86 36 39.6
A87 0 0
A88 8 8.8
A89 73 80.3
A90 85 93.5
A91 83 91.3
A92 48 52.8
A93 63 69.3
A94 28 30.8
A95 34 37.4
A96 16 17.6
A97 35 38.5
A98 79 86.9
A99 44 48.4
A100 53 58.3

Solutions

Expert Solution


Related Solutions

Break-Even Sales Currently, the unit selling price of a product is $380, the unit variable cost...
Break-Even Sales Currently, the unit selling price of a product is $380, the unit variable cost is $310, and the total fixed costs are $1,001,000. A proposal is being evaluated to increase the unit selling price to $420. a. Compute the current break-even sales (units). units b. Compute the anticipated break-even sales (units), assuming that the unit selling price is increased and all costs remain constant. units
2. Write the hexadecimal numbers in the registers of $a0, $a1, $a2, $a3 after the following...
2. Write the hexadecimal numbers in the registers of $a0, $a1, $a2, $a3 after the following codes running: ori $a0, $0, 11 ori $a1, $0, 19 addi $a1, $a1, -7 slt $t2, $a1, $a0 beq $t2, $0, label addi $a2, $a1, 0 sub $a3, $a1,$a0 j end_1 label: ori $a2, $a0, 0 add $a3, $a1, $a0 end_1: xor $t2, $a1, $a0 *Values in $a0, $a1, $a2, $a3 after the above instructions are executed.
Company records indicate the following data for widgets: Date Item Quantity Unit Cost Sales Price Sept....
Company records indicate the following data for widgets: Date Item Quantity Unit Cost Sales Price Sept. 1 Balance 17 $ 59 Sept. 3 Purchase 3 $ 71 Sept. 8 Sale 6 $ 118             Sept. 12 Sale 7 $ 107 The Cost of Goods (COGS) sold will be different depending upon whether the company uses LIFO or FIFO. Of course, the ending inventory would be different as well. The dollar difference between COGS computed using LIFO and COGS using FIFO...
Date Transaction Units In Unit Cost Total Units Sold Sales Price Total 7/1 Balance 100 4.10...
Date Transaction Units In Unit Cost Total Units Sold Sales Price Total 7/1 Balance 100 4.10 410 7/6 Purchase 800 4.20 3,360 7/7 Sale 300 7.00 2,100 7/10 Sale 300 7.30 2,190 7/12 Purchase 400 4.50 1,800 7/15 Sale 200 7.40 1,480 7/18 Purchase 300 4.60 1,380 7/22 Sale 400 7.40 2,960 7/25 Purchase 500 4.58 2,290 7/30 Sale 200 7.50 1,500 Totals 2,100 9,240 1,400 10,230 Compute FIFO, LIFO, Average for the perpetual inventory system. Be sure to do...
Date Transaction Units In Unit Cost Total Units Sold Sales Price Total 7/1 Balance 100 4.10...
Date Transaction Units In Unit Cost Total Units Sold Sales Price Total 7/1 Balance 100 4.10 410 7/6 Purchase 800 4.20 3,360 7/7 Sale 300 7.00 2,100 7/10 Sale 300 7.30 2,190 7/12 Purchase 400 4.50 1,800 7/15 Sale 200 7.40 1,480 7/18 Purchase 300 4.60 1,380 7/22 Sale 400 7.40 2,960 7/25 Purchase 500 4.58 2,290 7/30 Sale 200 7.50 1,500 Totals 2,100 9,240 1,400 10,230 Compute FIFO, LIFO, Average for the periodic inventory system. Be sure to do...
Swifty Corporation manufactures a product with a unit variable cost of $100 and a unit sales...
Swifty Corporation manufactures a product with a unit variable cost of $100 and a unit sales price of $176. Fixed manufacturing costs were $480000 when 10000 units were produced and sold. The company has a one-time opportunity to sell an additional 1000 units at $145 each in a foreign market which would not affect its present sales. If the company has sufficient capacity to produce the additional units, acceptance of the special order would affect net income as follows: Income...
If the unit sales price is $12, the unit variable cost is $7.00 and fixed costs...
If the unit sales price is $12, the unit variable cost is $7.00 and fixed costs are $125,000; what is the, break-even quantity in # of units? ___________________________________ Please Show steps
Question. Currently the unit selling price of a product is $200, the unit variable cost is...
Question. Currently the unit selling price of a product is $200, the unit variable cost is $110, and the total fixed costs are $585,000. A proposal is being evaluated to increase the unit selling price to $275. Under the proposed plan, the variable cost per unit and the total fixed cost will not change. Current Scenario [7 Points]: 1) Calculate the contribution margin per unit. 2) Calculate the contribution margin ratio. 3) Calculate the breakeven point in units under the...
Currently, the unit selling price of a product is $7,520, the unit variable cost is $4,400,...
Currently, the unit selling price of a product is $7,520, the unit variable cost is $4,400, and the total fixed costs are $23,400,000. A proposal is being evaluated to increase the unit selling price to $8,000. a. Compute the current break-even sales (units). _____________ units b. Compute the anticipated break-even sales (units), assuming that the unit selling price is increased and all costs remain constant. _______________units
PRODUCT 1 PRODUCT 2 Demand 80 80 Time/Unit 30 20 Sale Price 50 30 Variable Cost/Unit...
PRODUCT 1 PRODUCT 2 Demand 80 80 Time/Unit 30 20 Sale Price 50 30 Variable Cost/Unit 10 5 Contribution Margin/Unit 40 25 Contribution Margin Ratio 60% 40% Contribution Margin/Unit of Time 0.33 0.50 Assume the maximum time allowed is only 3,900 per day. Calculate and compare the profitability of the following scenarios: I. The product with the highest contribution margin prioritized. II. The product with the highest contribution margin per unit of constrained resource is prioritized. B How do managers...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT