,,, kindly solve
A B C D E 1 2 Milestone One - Variable and Fixed Costs Collars 7 Item Variable Cost/Item Item Fixed Costs 9 High-tensile strength nylon webbing 4.00 Collar maker's salary (monthly) 2,773.33 10 Polyesterylon ribbons 3.00 Depreciation on sewing machines 55.00 11 Buckles made of cast hardware 2.00 Rent 250.00 12 Price tags 0.10 Utilities and insurance 200.00 13 Scissors, thread, and cording 400.00 14 Loan payment 183.33 15 Salary to self 166.67 16 17 19 Total Variable Costs per Collar $ 9.10 Total Fixed Costs 4,028.35 20 22 23 Leashes 25 Item Variable Cost/Item Item Fixed Costs 27 High-tensile strength nylon webbing 6.00 Leash maker's salary (monthly) 2,773.33 28 Polyesterylon ribbons 4.50 Depreciation on sewing machines 55.00 29 Buckles made of cast hardware 1.50 Rent 250.00 30 Price tags 0.10 Utilities and Insurance 200.00 31 Scissors, thread, and cording 400.00 32 Loan payment 183.33 33 Salary to self 166.67 34 Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis COGS Type here to search m 10Milestone Two - Contribution Margin Analysis COLLARS LEASHES HARNESSES Sales Price per Unit 28.00 S 30.00 S 35.00 Variable Cost per Unit 9.10 12.10 14.60 11 Contribution Margin 5 18.90 17.90 5 20.40 12 14 15 16 17 A B C D E F G H Milestone Two - Break-Even Analysis W COLLARS LEASHES HARNESSES Sales Price S 28.00 30.00 35.00 Fixed Costs 5 4,028 4,028 S 4,202 10 11 Contribution Margin 18.90 S 17.90 20.40 12 13 Break-Even Units (round up) 214.00 226.00 206.00 14 16 17 Target Profit S 300.00 5 400.00 S 500.00 18 19 Break-Even Units (round up) 229.00 248.00 231.00 20 22 23 Target Profit 500.00 600.00 S 650.00 24 25 Break-Even Units (round up) 240.00 259.00 238.00 26133 X V J.x A B C D H 2 Milestone Three - Statement of Cost of Goods Sold W Beginning Work in Process Inventory 0 7 Direct Materials: 8 Materials: Beginning 0 9 Add: Purchases for month of January S 20,000 11 Materials available for use 20,000 12 Deduct: Ending materials 4,000 14 Materials Used 16,000 15 16 Direct Labor 8,493 17 Overhead 3,765 19 Total Costs S 28,258 20 21 Deduct: Ending Work in Process Inventory 0 22 23 Cost of Goods Sold S 28,258.00 24 25 26 27 28 292 Milestone Three - Income Statement 4 5 Revenue: 6 Collars S 12,880 7 Leashes 10,800 8 Harnesses 14,000 9 10 Total Revenue: S 37,680 11 Cost of goods sold 28,258 12 Gross profit S 9,422 13 14 Expenses: 15 General and administrative salaries S 2,450 16 Depreciation 165 17 Rent 750 18 Utilities and insurance 600 19 Scissors, thread, and cording 1,200.00 20 Loan 550 21 22 Total Expenses 5,715.00 23 24 Net Income/Loss S 3,707.00 25 26 27 29 30 Cost Classification Variable and Fixed Costs Contribution Margin Analy\fHello, I uploaded my errtire workbook so all the numbers can be found. The issue is with the nal page in the workbook 'v'ariance Analysis, the rest ofthe workbook is accurate. Is the data table for the materials and labor hours accurate? Budgeted hoursfgty, budgeted ratefqty, actual hoursfqty, and actual rate? The variances are: Thanks for any help! The help I am needing is with the final page in the workbook: Data for variance analysis: material and labor, then also with the 'Iu'ariance for collar sales. The actual variances from budget are: 'v'a riance At the end ofthe month, you nd that the labor and materials spent on manufacturing collars was different from what you estimated: - The collar maker had to work nine hours a day instead of eight due to an increased demand for collars. - Because of the increased demand, the hourly rate you paid your employee for making the collars increased to $16.50. - An increase in the cost of raw material led the direct material cost per collarto increase to $10. - However, you also made and sold ED more collars than you expected to sell in the month. You now need to determine the variance in the materials and labor cost from what you estimated in Milestone Two based on the market research data. I uploaded the first part of the workbook so that the budgeted information was available to view. Assume that w = = 1 and that * = k. Suppose that half of the fixed cost is nonsunk. For the following production functions, solve the short- run profit maximization problem, derive the short-run supply function, and represent it graphically. On your graph, pick a price above shutdown price and graphically represent the firm's (short-run) profit at that price and at the profit-maximizing quantity. At what price does the firm make zero profits? (a) f(1, k) = VIK. The firm's short-run supply function is if p v2. 19 0 or V2 if p = v2. Here Pahutdown - V2 and at price v 2 the firm is indifferent between shutting down and producing and selling % (2 is simply up when p = v2).(b) f (1, k ) = 1aka. In this case we have SC(() = # + k, NSC(q) = + 4, ANSO(q) = & + 1, SAC(q) = 4 + 4, and SMO(q) = 2 (soc Figure 1). Recall that the firm shuts down if p > 0. The q that minimizes ANSO(q) is ka "T. It can be found by setting ANSC(q) = SMC(q) and solving for q. The minimum of ANSC(q) (i.e., Pshutdown) is 343 It can be found by plugging & into either 13 SMC(q) or ANSC(q). Given p > Pshutdown, there is only one q such that p = SMO(): 4 = V 3. ke . Therefore, if pe 3ka 43 SS(p) = kp if p > wa 43 0 or if p = 3k$ (see Figure 1)- Consider price p* in Figure 1. At p* and at the corresponding profit- maximizing quantity, call it q', the firm makes negative (short-run) profits. Profits at (p*, q') are p*q* - SC(q*) = q"(p* - SAC(q*)), so (short-run) profits at (p*, q' ) are equal to negative the blue area of the rectangle in Figure 1. The price at which (short-run) profits are zero is the minimum of SAC(q)
