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
-
Gabriel Corporation sold $4,000,000, 8%, 10-year bonds on January 1, 2012. The bonds were dated January 1, 2012, and pay interest on July 1 and January 1. Gabriel Corporation uses the straight-line...
-
ANALYSIS AND DESIGN ASSIGNMENTS The purpose of the following assignments is to prepare aids that a designer of fluid power systems can use to specify appropriate sizes of steel tubing for a system...
-
Although the largest errors in calculating the height of a packed column are errors in (1) mass transfer coefficients and (2) VLE data, calculation errors can also be significant because calculation...
-
Belinda Lorenz has prepared the following list of statements about depreciation. 1. Depreciation is a process of asset valuation, not cost allocation. 2. Depreciation provides for the proper matching...
-
Analyze the impact of big data analytics in developing optimal strategies for partnership and strategic sourcing While global sourcing provides opportunity for better bottom line and customer...
-
You have been employed as a consultant to Golf R Us, Inc. The company has been having problems with account receivables and they want to use various dunning methods to better their receivables. But...
-
Scenario 6 Arthur is a tour manager at New Escapes, a tour agency specialising in outdoor-centric trips and experiences. As tour manager, he is responsible for making sure that the tour packages...
-
Globe Inc. is a distributor of DVDs. DVD Mart is a local retail outlet which sells blank and recorded DVDs. DVD Mart purchases DVDs from Globe at $29.00 per DVD; DVDs are shipped in packages of 65....
-
Following is information on an investment in a manufacturing machine. The machine has zero salvage value. The company requires a 9 % return from its investments. Initial investment $ ( 2 6 0 , 0 0 0...
-
4.44/5 E : According to www.money-zine.com, the average FICO score in the United States was around 692 in December 2011. Suppose the following data represent the credit scores of 22randomly selected...
-
The income statement for the Bramble Discount Retail Company for the year ended December 3 1 2 0 2 5 appears below. Sales revenue $ 6 1 9 , 0 0 0 Cost of goods sold 3 6 0 , 4 2 0 Gross profit 2 5 8 ,...
-
Data was collected for 300 fish from the North Atlantic. The length of the fish (in mm) is summarized in the GFDT below. Lengths (mm) Frequency 40 - 41 1 42 - 43 16 44 - 45 71 46 - 47 108 48 - 49 83...
-
After completing this project, you will have an understanding of what data is used to monitor the economy, and where it is found. The three key economic indicators are GDP, unemployment, and...
-
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.
-
Recording and processing information about a transaction at the time it takes place is referred to as which of the following? a. batch processing b. online, real-time processing c. captured...
-
Examine Table 2-1 and discuss how the various information needs would be collected and reported by a companys AIS. Table 2-1 Overview of S&S's Business Processes, Key Decisions, and Information Needs...
-
What are three basic methods for allocating factory overhead costs?
Study smarter with the SolutionInn App