The bookshop business you work for is sells a book series titled 'The wonderful world of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The bookshop business you work for is sells a book series titled 'The wonderful world of Business maths". There are three books in the series, called book 1, book 2 and book 3. The bookshop owner is concerned that sales are dropping. Instructions Your task is as follows: 1. You have been provided with sales data from Q3 (July, August, and September) in 2021 and 2022. Use a two-sample hypothesis test at 5% significance, to determine if the sales figures of the series as a whole are down from last year. To do this you will perform a hypothesis test on the mean monthly sales of the series, to see if the mean monthly sales have decreased. 2. Your boss believes that a small-scale advertising poster style campaign would be worthwhile in increasing sales of the series. You wish to know more concretely if this is true. To do this you will use data for various previous small-scale poster advertising campaigns for 7 different books sold at the company and perform a linear regression analysis, to see if there is a real correlation between sales and spending on advertising. Using your analysis, find the equation of the line of best fit, and determine how many book sales you expect with an advertising budget of $55,000? 3. Determine how many books would need to be sold to be profitable, based on whether or not advertising goes ahead, using the pricing data provided. a. Is the book series profitable already (based on the mean monthly sales figures from Q3 2022 provided)? b. Your boss has allocated a strict advertising budget of $55,000. Does your expected sales figure from part 2, suggest that you will be above or below the breakeven point with this advertising budget? Calculate the expected profit or loss using your expected sale figure from part 2 and your breakeven analysis. What if advertising was not done? Would this be a better decision based on your analysis for part 2? Data for Business Maths Assignment 4 - Report Part 1 Q3 sales for book series 2021 July August September 2022 July August September Part 2 - Previous poster sales vs book sales Book A B C D E F G Part 3 Break even analysis Fixed costs Staffing cost Advertising Storage Variable costs Shipping to store per 10 books $ Book cost per 10 books $ shipping to customer per book book 1 96 112 89 $ 86 79 108 Spending on advertising $ 44,000.00 $ 55,000.00 $ 4,000.00 15000 0 55000 175000 35000 80000 106000 12.00 100.00 6.50 Sale price per book $ 34.00 (all 3 books in the series have the same price) book 2 103 96 86 85 87 69 Total book sales 4161 3161 6420 18505 13155 15500 11180 book 3 85 75 105 66 80 91 The bookshop business you work for is sells a book series titled 'The wonderful world of Business maths". There are three books in the series, called book 1, book 2 and book 3. The bookshop owner is concerned that sales are dropping. Instructions Your task is as follows: 1. You have been provided with sales data from Q3 (July, August, and September) in 2021 and 2022. Use a two-sample hypothesis test at 5% significance, to determine if the sales figures of the series as a whole are down from last year. To do this you will perform a hypothesis test on the mean monthly sales of the series, to see if the mean monthly sales have decreased. 2. Your boss believes that a small-scale advertising poster style campaign would be worthwhile in increasing sales of the series. You wish to know more concretely if this is true. To do this you will use data for various previous small-scale poster advertising campaigns for 7 different books sold at the company and perform a linear regression analysis, to see if there is a real correlation between sales and spending on advertising. Using your analysis, find the equation of the line of best fit, and determine how many book sales you expect with an advertising budget of $55,000? 3. Determine how many books would need to be sold to be profitable, based on whether or not advertising goes ahead, using the pricing data provided. a. Is the book series profitable already (based on the mean monthly sales figures from Q3 2022 provided)? b. Your boss has allocated a strict advertising budget of $55,000. Does your expected sales figure from part 2, suggest that you will be above or below the breakeven point with this advertising budget? Calculate the expected profit or loss using your expected sale figure from part 2 and your breakeven analysis. What if advertising was not done? Would this be a better decision based on your analysis for part 2? Data for Business Maths Assignment 4 - Report Part 1 Q3 sales for book series 2021 July August September 2022 July August September Part 2 - Previous poster sales vs book sales Book A B C D E F G Part 3 Break even analysis Fixed costs Staffing cost Advertising Storage Variable costs Shipping to store per 10 books $ Book cost per 10 books $ shipping to customer per book book 1 96 112 89 $ 86 79 108 Spending on advertising $ 44,000.00 $ 55,000.00 $ 4,000.00 15000 0 55000 175000 35000 80000 106000 12.00 100.00 6.50 Sale price per book $ 34.00 (all 3 books in the series have the same price) book 2 103 96 86 85 87 69 Total book sales 4161 3161 6420 18505 13155 15500 11180 book 3 85 75 105 66 80 91
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The global automaker you work for is investing in an automobile assembly facility in Costa Rica with a local partner. Explain the potential reasons for this investment. Will your company want to...
-
The company you work for is considering a new product line projected to have the net cash flows (NCF) shown. The values are in future dollars, which have been inflated by 5% per year. Because the...
-
The integrated delivery system you work for is thinking about dropping your sleep disorder program for financial reasons. The program serves 4,000 patients a year with annual revenues of $2 million....
-
50 successes in 200 trials when p = 0.2. For the binomial experiments find the normal approximation for the probability of
-
The Tower family wants to make a home improvement that is expected to cost $60,000. They want to fund as much of the cost as possible with a home equity loan but can afford payments of only $600 per...
-
Suppose that for a financial institution, one-year rate sensitive assets (RSAs) are $240 million, and the one-year rate sensitive liabilities (RSLs) are $185 million. Total assets of the financial...
-
A car rental agency has 19 compact cars and 12 intermediate-size cars. If four of the cars are randomly selected for a safety check, what is the probability of getting two of each kind?
-
A tissue manufacturer that has the fourth-largest market share plans to experiment with a 50 off coupon during November and a buy one, get one free coupon during December. The experiment will take...
-
The Jones Company has just completed the third year of a five-year MACRS recovery period for a piece of equipment it originally purchased for $300,000. a. What is the book value of the equipment? b....
-
La-Z-Boy Incorporated included the following information in its 2009 annual report (dollars in millions). Define solvency and discuss how this information might be useful in assessing the company??s...
-
(c) Given, ax+b f(x) = and g(x) = mx cx+d Determine the domain of fo g and gof
-
Determine the mean free math of an air molecule with an air temperature of 1 2 . 0 deg C and atmospheric pressure of 1 . 0 0 bar. Model an air molecule as a sphere with a radius of 0 . 2 0 nm .
-
6. Two mirrors are placed at right angles to each other. A candle is placed a distance of about 5 cm from each mirror. Using the first law of specular reflection, the number of images of the candle...
-
Which collision has momentum conserved but not kinetic energy ? Question 6 options: a ) explosion b ) closed c ) elastic d ) inelastic
-
8 When a lightbulb is turned on, 80 C of charge pass through the filament of the bulb in 35.0 s. How many electrons pass through the filament in 7.5 s? (Enter 3 significant number in exponent...
-
In a typically lit room, the light intensity is around 1 W x m ^ - 2 . Estimate the number of photons hitting your body each second when you are sitting in a regular classroom.
-
Horseshoe Inc. has sales of $17500000, total assets of $12700000, and total debt of $4500000. If the net income is 700000, what is the return on assets? Convert to a percent and round to two places...
-
The diagram shows the two forces acting on a small object. Which of the following is the resultant force on the object? A. 8 N downwards B. 8 N upwards C. 2 N downwards D. 2 N upwards 3 N 5 N
-
Select the best answer choice for each of the following items. 1. Perez Companys operations are unrelated to the operations of its subsidiary. Certain balance sheet accounts of the foreign subsidiary...
-
Eleven funds are recommended to account for the various activities and resources of a govern mental unit. Identify these funds by title and type and briefly state (in two sentences or less) the basic...
-
Identify three types of transactions that result in a change in a parent company's ownership interest in its subsidiary.
-
Jakari Smith is a new client and has been an investment advice provider as well as an income tax preparer for a well- established firm in the city. He would like to start his own firm as an S...
-
Distinguish between a primary authority and a secondary authority.
-
Maverick and Melanie Hall are selling their current home and purchasing another larger home for their growing family. You will review a list of improvements provided by the Halls, and the settlement...
Study smarter with the SolutionInn App