The Snazzy Pup Company makes many items and one of them is a special dog collar....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Snazzy Pup Company makes many items and one of them is a special dog collar. The following information pertains to the product: Accounting 2120 Fall 2020 Cost Analysis Computer Project #3 - Version A (40 Points) Due by Friday, October 30 ORIGINAL DATA Sales in units Per item: Sales price Product Costs: Materials Labor Factory Overhead Total Cost In total: Selling costs Administrative costs Collars 40,000 $15.00 $ 3.00 $ 2.00 $1.00 $ 6.00 $125,000 $200,000 REQUIRED: On the basis of the facts as given above, prepare the following schedules using a spreadsheet software package (preferably Excel). Each situation is independent of the others. A. Prepare the income statement using the original data. B. Snazzy Pup is thinking of adding more sales people. This will double the selling costs. Assume they can double the number of items sold with this change. Prepare a new income statement showing these changes. C. Snazzy Pup is wondering what would happen if they only sell half as many items. Assume selling and administrative costs stay the same. Prepare a new income statement showing these changes. D. Snazzy Pup is considering cutting sales prices to $12.00 per collar in hopes of doubling sales. Assume selling and administrative costs stay the same. Prepare a new income statement showing these changes. E. Use Goal Seek in Excel (Data/What If Analysis/Goal Seek) to determine the following: Each situation is independent of the others. 1) Assume the only change to the original data is that sales double, what sales price per item is needed to get the same net income as in Part B7 2) Assume the original data including unit sales, what is the total cost per unit needed to get the same net income as in Part B? 3) Assume the only change to the original data is that the sales price decreases to $12.00 per unit and sales in units double, what would selling costs need to be to get the same net income as in Part B? F. GO BACK TO THE ORIGINAL DATA. Use Solver in Excel to determine the following assuming these constraints: Sales price not more than $16.00 per unit Sales price not less than $10.00 per unit. Product costs not more than $8.00 unit. per Product costs not less than $4.00 per unit Administrative costs not more than $225,000. Administrative costs not less than $100,000. Sales in units not more than 100,000 Sales in units not less than 20,000 . . ● ● . . Each situation is independent of the others. 1. How many units must be sold in order to get the same net income as in Part B? 2. What is the maximum net income Snazzy Pup can achieve with the above constraints? 3. What is the minimum net income Snazzy Pup can achieve with the above constraints? G. GO BACK TO THE ORIGINAL DATA. Use Scenario Manager in Excel. Prepare and print a Scenarios Summary Report for net income with the following options: Each situation is independent of the others. 1. Big Sale-Both sales in units and selling expenses double 2. Worst case - Sales in units are half as much as the original amount. 3. Lower prices - Sales price per unit decrease to $12.00 and sales in units double. 4. Lower unit costs - Product cost per unit decreases to $5.00. 5. Lower administrative costs - Administrative costs decline to $150,000 which causes a decrease in unit sales of 10%. 6. Change two - Sales in units increase by 50% and sale price per unit decreases to $14 per unit. 7. Makeover - An exclusive model is introduced. This causes sales in units to increase by 10,000, the sales price per unit to increase to $20, unit costs increase by $2.00, and selling costs increase to $175,000. The Snazzy Pup Company makes many items and one of them is a special dog collar. The following information pertains to the product: Accounting 2120 Fall 2020 Cost Analysis Computer Project #3 - Version A (40 Points) Due by Friday, October 30 ORIGINAL DATA Sales in units Per item: Sales price Product Costs: Materials Labor Factory Overhead Total Cost In total: Selling costs Administrative costs Collars 40,000 $15.00 $ 3.00 $ 2.00 $1.00 $ 6.00 $125,000 $200,000 REQUIRED: On the basis of the facts as given above, prepare the following schedules using a spreadsheet software package (preferably Excel). Each situation is independent of the others. A. Prepare the income statement using the original data. B. Snazzy Pup is thinking of adding more sales people. This will double the selling costs. Assume they can double the number of items sold with this change. Prepare a new income statement showing these changes. C. Snazzy Pup is wondering what would happen if they only sell half as many items. Assume selling and administrative costs stay the same. Prepare a new income statement showing these changes. D. Snazzy Pup is considering cutting sales prices to $12.00 per collar in hopes of doubling sales. Assume selling and administrative costs stay the same. Prepare a new income statement showing these changes. E. Use Goal Seek in Excel (Data/What If Analysis/Goal Seek) to determine the following: Each situation is independent of the others. 1) Assume the only change to the original data is that sales double, what sales price per item is needed to get the same net income as in Part B7 2) Assume the original data including unit sales, what is the total cost per unit needed to get the same net income as in Part B? 3) Assume the only change to the original data is that the sales price decreases to $12.00 per unit and sales in units double, what would selling costs need to be to get the same net income as in Part B? F. GO BACK TO THE ORIGINAL DATA. Use Solver in Excel to determine the following assuming these constraints: Sales price not more than $16.00 per unit Sales price not less than $10.00 per unit. Product costs not more than $8.00 unit. per Product costs not less than $4.00 per unit Administrative costs not more than $225,000. Administrative costs not less than $100,000. Sales in units not more than 100,000 Sales in units not less than 20,000 . . ● ● . . Each situation is independent of the others. 1. How many units must be sold in order to get the same net income as in Part B? 2. What is the maximum net income Snazzy Pup can achieve with the above constraints? 3. What is the minimum net income Snazzy Pup can achieve with the above constraints? G. GO BACK TO THE ORIGINAL DATA. Use Scenario Manager in Excel. Prepare and print a Scenarios Summary Report for net income with the following options: Each situation is independent of the others. 1. Big Sale-Both sales in units and selling expenses double 2. Worst case - Sales in units are half as much as the original amount. 3. Lower prices - Sales price per unit decrease to $12.00 and sales in units double. 4. Lower unit costs - Product cost per unit decreases to $5.00. 5. Lower administrative costs - Administrative costs decline to $150,000 which causes a decrease in unit sales of 10%. 6. Change two - Sales in units increase by 50% and sale price per unit decreases to $14 per unit. 7. Makeover - An exclusive model is introduced. This causes sales in units to increase by 10,000, the sales price per unit to increase to $20, unit costs increase by $2.00, and selling costs increase to $175,000.
Expert Answer:
Related Book For
Financial Reporting and Analysis
ISBN: 978-0078025679
6th edition
Authors: Flawrence Revsine, Daniel Collins, Bruce, Mittelstaedt, Leon
Posted Date:
Students also viewed these accounting questions
-
What would happen if it turned out that RPM did not have a legitimate reason for stopping payment on the check? RPM Pizza, Inc., issued a check for $96,000 to Systems Marketing for an advertising...
-
What would happen if retailer-organized channels (either formally integrated or administered) dominated consumer products marketing?
-
What would happen if you mistakenly used an ammeter where you needed to use a voltmeter?
-
Calculate the covariance of returns on the foreign index and the returns on the domestic index. An analyst produces the following joint probability function for a foreign index (FI) and a domestic...
-
Tannhauser Financial is a banking services company that offers many different types of checking accounts. It has recently adopted an activity-based costing system to assign costs to various types of...
-
A shaft is subjected to (a) axial load only (b) bending loads only (c) torsional loads only (d) all of the above
-
What is the purpose of the System Operations Model and how does it aid development of the ConOps?
-
Joint Cost Allocation, processing further and ethics. Unified Chemical Company has a joint production process that converts Zeta into two chemicals: Alpha and Beta. The company purchases Zeta for $12...
-
The System Architecture Definition process works in conjunction with which other SE Technical Process to determine the system context and refine the system boundary? Explain
-
As she headed toward her boss's office, Emily Hamilton, chief operating officer for the Aerocomp Corporation-a computer services firm that specialized in airborne support-wished she could remember...
-
Wall Street performs a sort of "financial alchemy" enabling the individual to benefit from institutions lending money to them, according to Adam Davidson, co-founder of NPR's "Planet Money."...
-
At the beginning of the year, Golden Gopher Company reports a balance in Supplies of $430. During the year, Golden Gop purchases an additional $2,600 of supplies for cash. By the end of the year,...
-
"This is really an odd situation, said Jim Carter, general manager of Highland Publishing Company. "We get most of the jobs we bid on that require a lot of press time in the Printing Department, yet...
-
Sthilaire Corporation is working on its direct labor budget for the next two months. Each unit of output requires 0.64 direct labor-hours. The direct labor rate is $9 per direct labor-hour. The...
-
Enter the missing values to balance the equations. = Assets Liabilities + Equity = 28,000+29,000 75,000 = + 34,000 65,000 = 18,000 +
-
Baird Corporation produced 215,000 watches that it sold for $19 each during year 2. The company determined that fixed manufacturing cost per unit was $8 per watch. The company reported a $1,075,000...
-
Let L={w: w is any string in {0, 1} that does NOT contain the substring 01} a) Write the grammar for L (3) b) Construct the machine M for L using the 'complement' closure property by constructing the...
-
Parkin Industries, a U.S. company, acquired a wholly-owned subsidiary, located in Italy, at the beginning of the current year, for 200,000. The subsidiary's functional currency is the euro. The...
-
ClearOne Communications, Inc., is a provider of end-to-end video and audio conferencing services, including the manufacture and sale of video and audio conferencing products. From its inception as a...
-
The following information pertains to Sparta Companys defined benefit pension plan: Discount rate ............ 8% Expected rate of return on plan assets . 10% Average service life ....... 12 years At...
-
On January 1, 2014, Bare Trees Company signed a three-year noncancelable lease with Dreams Inc. The lease calls for three payments of $62,258.09 to be made at each year-end. The lease payments...
-
The unadjusted trial balance of Innovative Computers Pty Ltd on 30 June 2025 is presented below. The following additional information is available. 1. The inventories as of 30 June 2025 were as...
-
The Z-spread of Bond A is 1.05% and the Z-spread of Bond B is 1.53%. All else equal, which statement best describes the relationship between the two bonds? A. Bond B is safer and will sell at a lower...
-
In most countries, the bond market sector with the smallest amount of bonds outstanding is most likely the: A. government sector. B. financial corporate sector. C. non-financial corporate sector.
Study smarter with the SolutionInn App