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...
-
1. What organizational changes would you suggest for DVS procurement? 2. What types of computerization changes would you recommend? 3. How would e-commerce benefit the DVS procurement? 4. Would you...
-
In what ways have smart phones that incorporate wireless technologies changed the business landscape?
-
Provide an example for actor generalization. What is the significance of generalizing or specializing actors?
-
Go to the books companion website and use information found there to answer the following questions related to The Coca-Cola Company and PepsiCo, Inc. (a) Compute the debt to total assets ratio and...
-
A new wave-soldering machine is expected to save Burnaby Circuit Boards $16,000 per year through reduced labour costs and increased quality. The device will have a life of nine years and will have no...
-
The following balances were taken from the book of JACK Partnership as of July 1, 2015 when the partnership decided to liquidate: Accounts Receivable, net Furniture & Fixtures, net Sales Proceeds...
-
S Pellah beginning capital $80,000 and M Berry beginning capital $120,000 are partners. During 2017 the partnership earned net income of $90,000 and Pellah made drawings of $24,000 while Berry made...
-
The space age bicycle rim in Figure 4.88 can be modeled as a thin disk with four circular cutouts, which are of identi- cal size. The density of the disk material is kg/m2 . In Figure 4.88, the rim...
-
1. How is heat transfer related to temperature? Describe a situation in which heat transfer occurs. What are the resulting forms of energy? When heat transfers into a system, is the energy stored as...
-
Saturn's moon Kiviuq was discovered by a Canadian-led team in 2000. It has a semimajor axis of 11,000,000 km. What is its orbital period around Saturn, in Earth days?
-
Mary and Tim are on a 2.5 m board as shown. The board has a mass of 3.5 kg. If Mary weight is 36 N and Tim has mass of 83 kg, determine the following assuming that they were paddle boarding in a...
-
If one terminal each of three separate resistors of 4 ohms, 3 ohms, and 1 ohm resistance is connected to the positive terminal of a 12 volt battery and the other terminal of each of the resistors is...
-
QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...
-
Using the information in P11-2B, compute the overhead controllable variance and the overhead volume variance. Data From Problem 11-2B: Huang Company uses a standard cost accounting system to account...
-
Following up on question number 3, assume the school conducts a manifestation determination meeting. Tim attends the meeting with his parents. At the meeting, Tim tells the team that smoking helps...
-
Which is an advantage to an employee who participates in a profit-sharing plan? A. Employee does not have to make investment decisions. B. Graded vesting schedule. C. Older employees receive the...
-
Which of the following is not a characteristic of a defined benefit plan? A. A guaranteed retirement benefit. B. Risk of preretirement inflation assumed by employer. C. Benefits based upon the...
Study smarter with the SolutionInn App