Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Alternative 1 please. Compiled list of total costs from past 12 months > You are the bookkeeper for a small start-up company that sells plush
Alternative 1 please. Compiled list of total costs from past 12 months > You are the bookkeeper for a small start-up company that sells plush teddy bears that are so adorable! See? Awwwwwwwww.... The company is called Granny Joe's Bears (GJB). It was started by Josephine and Stanley Snerdley. Josephine has been designing and making teddy bears for decades, and finally she listened to people who told her she should mass-produce and market her teddy bears. GJB began two years ago and has been doing rather well. The grandkids help out by managing online sales, and GJB has a very small store on the Riverwalk. The rest of the family members told Granny Joe and Grampy Stan it was time to change the pricing and/or the current cost structure. They got the idea while taking the clutchiest class in accounting at St Mary's. But Granny and Grampy really don't understand the finances of the business, and they are confused. You decided to help them out by creating a spreadsheet that will display some of the information in graphs. They both love graphs. You compiled a list of the total costs for the last 12 months. You can download this information from BB he Snerdley grandkids have a couple ideas for changes. Alternative A Raise the current selling price from $11.20 per bear to $13.20 per bear. This will not change the cost structure at all, but the kids estimate that this will reduce the monthly sales by 100 bears per month. For example, if GJB sold 800 units last January when the price was $11.20 per bear, they estimate that GJB could sell 700 units this January if the price was $13.20 per bear. Alternative B Keep the current selling price, but lease a new super-efficient sewing machine. This will cost $1100 per month, but it will save $1 per bear in variable costs. Instruction Create a spreadsheet that looks like the template shown on the next page. Use the MAX and MIN functions in Excel to determine the high and low sales levels for the 12 month data. Under that, create
Compiled list of total costs from past 12 months >
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started