MILESTONE THREE VARIANCE ANALYSIS MILESTONE THREE STATEMENT OF COST OF GOODS SOLD MILESTONE THREE INCOME STATEMENT PLEASE
Fantastic news! We've Found the answer you've been seeking!
Question:
MILESTONE THREE VARIANCE ANALYSIS
MILESTONE THREE STATEMENT OF COST OF GOODS SOLD
MILESTONE THREE INCOME STATEMENT
PLEASE INCLUDE ALL EASY TO READ EXCEL FORMULAS
Transcribed Image Text:
Milestone One - Variable and Fixed Costs Collars Variable Cost/Item Item High-tensile strength nylon webbing $ Polyester/nylon ribbons Buckles made of cast hardware Price tags Item Fixed Costs 4.00 Collar maker's salary (monthly) Depreciation on sewing machines 2,773.33 3.00 55.00 2.00 Rent 250.00 0.10 Utilities and insurance 200.00 Scissors, thread, and cording 400.00 Loan payment 183.33 Salary to self 166.67 Total Variable Costs per Collar 9.10 Total Fixed Costs 4,028.34 Milestone Two: Market Research Data You have conducted some market research for style and size of products you want to use to launch your business. The market research has indicated the following sales price ranges will be optimal for your area depending on style of products you choose to sell: • Collars • With pricing at $20 per collar, you can expect to sell 30 collars per day. o With pricing at $24 per collar, you can expect to sell 25 collars per day. o With pricing at $28 per collar, you can expect to sell 20 collars per day Leashes • With pricing at $22 per leash, you can expect to sell 28 leashes per day. • With pricing at $26 per leash, you can expect to sell 23 leashes per day. • With pricing at $30 per leash, you can expect to sell 18 leashes per day. Harnesses o With pricing at $25 per harness, you can expect to sell 25 harnesses per day. o With pricing at $30 per harness, you can expect to sell 22 harnesses per day. o With pricing at $35 per harness, you can expect to sell 20 harnesses per day. Additionally, you will need to compare your break-even points for the following target profits for each area of your business to determine your prices: Collars O Break-even o $300 target profit each month • $500 target profit each month SSS Milestone One - Variable and Fixed Costs Collars Variable Cost/Item Item High-tensile strength nylon webbing $ Polyester/nylon ribbons Buckles made of cast hardware Price tags Item Fixed Costs 4.00 Collar maker's salary (monthly) Depreciation on sewing machines 2,773.33 3.00 55.00 2.00 Rent 250.00 0.10 Utilities and insurance 200.00 Scissors, thread, and cording 400.00 Loan payment 183.33 Salary to self 166.67 Total Variable Costs per Collar 9.10 Total Fixed Costs 4,028.34 Milestone Two: Market Research Data You have conducted some market research for style and size of products you want to use to launch your business. The market research has indicated the following sales price ranges will be optimal for your area depending on style of products you choose to sell: • Collars • With pricing at $20 per collar, you can expect to sell 30 collars per day. o With pricing at $24 per collar, you can expect to sell 25 collars per day. o With pricing at $28 per collar, you can expect to sell 20 collars per day Leashes • With pricing at $22 per leash, you can expect to sell 28 leashes per day. • With pricing at $26 per leash, you can expect to sell 23 leashes per day. • With pricing at $30 per leash, you can expect to sell 18 leashes per day. Harnesses o With pricing at $25 per harness, you can expect to sell 25 harnesses per day. o With pricing at $30 per harness, you can expect to sell 22 harnesses per day. o With pricing at $35 per harness, you can expect to sell 20 harnesses per day. Additionally, you will need to compare your break-even points for the following target profits for each area of your business to determine your prices: Collars O Break-even o $300 target profit each month • $500 target profit each month SSS
Expert Answer:
Answer rating: 100% (QA)
Answer Income Statement Revenue Collar 1320000 Leashes S 1232000 Harnesses 1250000 Total Revenue 380... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Statement of Cost of Goods Manufactured for a Manufacturing Company Cost data for F. Mills Manufacturing Company for the month ended May 31, 2014, are as follows: Inventories May 1 May 31 Materials...
-
Statement of Cost of Goods Sold : Prepare the statement of cost of goods sold in the COGS tab of the workbook. Remember to show your work using calculations to the side of the table or using...
-
Manufacturing Income Statement, Statement of Cost of Goods Manufactured Several items are omitted from the income statement and cost of goods manufactured statement data for two different companies...
-
CMOS Chips is hedging a 20-year, $21 million, 8% bond payable with a 20-year interest rate swap and has designated the swap as a fair value hedge. The agreement called for CMOS to receive payment...
-
Discuss examples of market incentives used to address environmental problems.
-
List and describe 10 possible review areas that auditors may be involved in during the development process.
-
What is three octaves above \(\mathrm{G}_{2}\) ? State the requested note.
-
Kristen Montana operates a retail clothing operation. She purchases all merchandise inventory on credit and uses a periodic inventory system. The accounts payable account is used for recording...
-
Mia Limited is considering upgrading its plant to expand it client base. The financial details of the investment proposal are as follows: Cost of plant R 4 5 0 0 0 0 0 Import duty R 7 0 0 0 0 0...
-
Baer Belly Bikinis, Inc. (BBB) is a small business located in Santa Monica, California. It sells swimwear and related products to specialty stores throughout the United States. It also sells its...
-
The count in a bacteria culture was 300 after 15 minutes and 1800 after 35 minutes Assuming the count grows exponentially What was the initial size of the culture bacteria Find the doubling period...
-
Discuss progressive discipline and how it impacts fire service personnel management. Consider discussing your role in progressive discipline if you have one. Have you ever been a part of the...
-
Compare the chosen subsystem for change which are training and development to dollar tree to the same subsystem in a different organization. The subsystem chosen should be from an organization that...
-
What contribution does quality management make if we use the Critical Path Operations Management Model in a construction company?
-
Explain the organizational and management structure? What do you think about the notion that elimination of traditional management positions or incorporation of new ones also change the way of...
-
Discuss the following techniques: a. Management by objectives. b. Management by exception.
-
Solve the equation Check your solutions Enter your answers as a comma separated list x2 5 3 2 27 x Incorrect Your answer is incorrect
-
Calculate the Lagrange polynomial P 2 (x) for the values (1.00) = 1.0000, (1.02) = 0.9888, (1.04) = 0.9784 of the gamma function [(24) in App. A3.1] and from it approximations of (1.01) and (1.03).
-
During 20x7, Wells Corporation reported a net income of $1,338,400. On January 1, Wells had 720,000 shares of common stock outstanding. The company issued an additional 480,000 shares of common stock...
-
Using the corporate tax rate schedule in Table 1, compute the income tax liability for taxable income of (1) $800,000 and (2) $40,000,000. Earnings per Share
-
Refer to the statement of stockholders equity for Kavra Corporation in Exhibit 5 to answer the following questions: (1) At what price per share were the 5,000 shares of common stock sold? (2) What...
Study smarter with the SolutionInn App