Excel Exercise # 10 - Analyze Data_Hannon

A printer manufacturer estimates that the average purchaser of a printer will also purchase six ink refills over the lifetime of the printer. The relevant data are: Printer: price: $400, margin: $100 Refills: price: $40, margin: $30 The manufacturer is considering increasing the price of printers by 10% to $440. What volume decrease in the sales of printers is the stay-even sales change for the firm? (Ignore the issue of discounting the value of future ink refill sales. Imagine, for example, that all six are purchased upfront with the printer). A. 11.5% B. 12.5% C. 13.5% D. 14.5% Use = % Q = (Pold - Cold)/(Pnew - Cold) - 1

help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working

The price for cigarettes sold by Big Tobacco Co Ltd was6.00 per packet in March 2018. During the month of March, the consumption of cigarettes was 1000 packets. However, the Board of Directors of Big Tobacco Co Ltd decided to increase the price by 25% during the month of April.  As a manager you noted that price elasticity of demand was 0.8. As a manager Big Tobacco Co Ltd:   Advise your management ofthe strategy that could be adopted by your firm to maintain sales.

The table below is extracted from Goodland Republic Bureau of Statistics records for 2016 -2017. Use the information to answer the questions that follow. Goodland Economy 2013 and 2018 I tem Price 2017 (Base year) Price 2018 Price per Price per Unit ($) | Production 55,000 98,000 45,000 2,450.00 110,000 6.000 7,000.00 Unit ($) Production 50,000 100,000 50,000 23,000.00 120,000 5,000 Rice ( tons) Wheat (tons) Tractors mid-size (units) Cotton (tons) Used cars Manufacture garments ( tons) Eggs (Trays) Соса Cola (litres) Pepsi Cola (litres) Beef (tons) Second hand cloths (tons) Alcoholic Beverages (litres) Milk (litres) 1.50 2.00 2.00 2.50 100.00 120.00 5,000.00 50.00 150,000 2,000 6,000 700 145,000 2,300 6,500 70.00 2.50 3.50 0.80 1.20 1.50 1.10 850 5,000 500 500 4,800 450 600 6.50 8.50 15.00 25.00 3.25 3.75 7,000 2.30 7,500 2.50 Examine the status of the economic welfare in Goodland Republic in 2018 based on your GDP deflator, nominal GDP and Real GDP. Also, explain the reasons why it is…

Need graphs, as well as the following:

The table below is extracted from Goodland Republic Bureau of Statistics records for 2016 -2017. Use the information to answer the questions that follow. Item     Price 2017 (Base Year)   Price 2018 Production Price per Unit ($) Production Price per Unit ($) Rice (tons) 50,000 1.50 55,000 2.00 Wheat (tons) 100,000 2.00 98,000 2.50 Tractors mid-size (units) 50,000 23000.00 45,000 2,450.00 Cotton (tons) 120,000 100.00 110,000 120.00 Used cars 5,000 5,000.00 6,000 7,000.00 Manufacture garments (tons) 150,000 50.00 145,000 70.00 Eggs (trays) 2,000 2.50 2,300 3.50 Coca Cola (litres) 6,000 0.80 6,500 1.20 Pepsi Cola (litres) 700 1.10 850 1.50 Beef (tons) 5,000 6.50 4,800 8.50 Second Hand Clothes (tons) 500 15.00 450 25.00 Alcoholic Beverages (litres) 500 3.25 600 3.75 Milk (litres) 7,000 2.30 7,500 2.50 Examine the…

RCO Manufacturing is an electronics manufacturer and retailer. Its main products are ultrabook computers, PCs and calculators.  The current price of the ultrabook is £500, the PC is £800 and the calculator is £40. This year the firm sold 10,000 ultrabooks, 20,000 PCs and 1 million calculators. In an attempt to improve revenue the managers of the firm have decided to increase all prices by 10%. Market research has suggested that the price elasticity of demand for each product is: Ultrabook: (-) 1.5;  PC : (-) 2.5;  calculator:  (-) 0.6 You have been asked to evaluate the planned price increases. Comment on the planned price changes. Would a 10% price reduction have been better for some or all of the products? What benefit (if any) would advertising bring to the firm? (You should support any arguments with calculations.)

You are an economist. Your friend started a new business selling masks. She asked for your help in making some important decisions. From the data obtained from her, you computed the Price Elasticity of Demand (PED) of Masks, and found absolute PED in February was 1.26, and since then the absolute PED of Masks declined by 30% in June. (a) Based on the PED of June, you would advise your friend for an increase/decrease/unchanged in the price - Insert one word answer (increase/decrease/unchanged) (b) The market price of the mask in July was Tk15 per unit. The total revenue earned in July was Tk300. You received the data for August and observed that the price now in August is Tk26 per unit and the quantity of masks sold in August is 9 units. Calculate the absolute value of Price Elasticity of Demand (PED) for masks from July to August. Do not convert into percentage. Give your answer in 2 decimal places. Eg. If you get PED = -0.253 then submit 0.25

You are an economist. Your friend started a new business selling masks. She asked for your help in making some important decisions. From the data obtained from her, you computed the Price Elasticity of Demand (PED) of Masks, and found absolute PED in February was 1.86, and since then the absolute PED of Masks declined by 55% in June. (a) Based on the PED of June, you would advise your friend for an increase/decrease/unchanged in the price - (b) The market price of the mask in July was Tk20 per unit. The total revenue earned in July was Tk300. You received the data for August and observed that the price now in August is Tk28 per unit and the quantity of masks sold in August is 12 units. Calculate the absolute value of Price Elasticity of Demand (PED) for masks from July to August.

Ypsilanti Market Research conducted a survey to find out whether people who earn more money purchase more expensive goods. The following graph indicates the relationship between income the survey subjects earned and the price of the home that they purchased. PRICE (Thousands of dollars per home) 500 450 400 350 300 250 200 150 100 50 L 0 10 20 30 40 50 60 70 80 INCOME (Thousands of dollars per year) 90 100

A firm keeps a record of sales and prices over the past seven months, resulting in the following table: Price (ZMW/ton) Sales (tons) Nov. 1985 7.5 84.5 Dec. 8.0 82.0 Jan. 1986 8.0 84.0 Feb. 7.2 92.0 March 7.0 95.0 April 8.0 92.0 May 8.5 91.5 Use these observations to estimate demand as a linear function of both price and time. Further, utilise this function to estimate demand for the following month, on the assumption that: (a) price remains unchanged, (b) price increases to ZMW9/ton. Hence estimate the price elasticity of demand between these prices and find the price which would maximise sales revenue. Given the nature of the observations, comment on any difficulties in interpreting your results for decision-making purposes.

The monthly demand of a company is showed below, please use the static method to forecast the demand for Year 6. Sales Year 1 Year 2 Year 3 Year 4 Year 5 JAN 2,000 3,000 2,000 5,000 5,000 FEB 3,000 4,000 5,000 4,000 2,000 MAR 3,000 3,000 5,000 4,000 3,000 APR 3,000 5,000 3,000 2,000 2,000 MAY 4,000 5,000 4,000 5,000 7,000 JUN 6,000 8,000 6,000 7,000 6,000 JUL 7,000 3,000 7,000 10,000 8,000 AUG 6,000 8,000 10,000 14,000 10,000 SEP 10,000 12,000 15,000 16,000 20,000 OCT 12,000 12,000 15,000 16,000 20,000 NOV 14,000 16,000 18,000 20,000 22,000 DEC 8,000 10,000 8,000 12,000 8,000 Total 78,000 89,000 98,000 115,000 113,000

d. XYZ company specializes in supplying online sofa bed and wish to increase its total revenue. Based on the online data, XYZ company knows that its customers can be divided into two distinct markets: West coast Malaysia (WCM) and East coast Malaysia (ECM). The following table shows how the two regions respond to a 30% rebate: Volume of sales before West coast Malaysia East coast Malaysia the 30% rebate (sales per month) (sales per month) 500 300 Volume of sales after the 30% rebate 2000 400 į Using the midpoint method, calculate the price elasticities of demand for both regions. ii. If XYZ company wants to boost its sales and income, should the rebate be offered to West coast Malaysia or East coast Malaysia, or both regions, or neither regions? Justify your answer.

Q10

The price for cigarettes sold by Big Tobacco Co Ltd was 6.00 per packet in March 2018. During the month of March, the consumption of cigarettes was 1000 packets. However, the Board of Directors of Big Tobacco Co Ltd decided to increase the price by 25% during the month of April.  As a manager you noted that price elasticity of demand was 0.8. As a manager Big Tobacco Co Ltd:   As a manager Big Tobacco Co Ltd store advise your management of the strategy that could be adopted by your firm to maintain sales

Examine the following statement and determine the accuracy of the statement.  Cars are considered as luxury items. Thus, a decrease in the consumer's income would result in a decrease in the demand for cars.  Consumer income will affect the demand for a product.  The future expectancy of a product will affect the demand for the product. Future expectancy not only encompasses the future price of a product but also other factors that will affect the demand for product such as advancement in technology and government policy.

the following data represents a set do demands that have occurred over the last several years at a soap making company.  The data were collected on an annual basis. Year Actual Demand (At) Forecast (Ft) 1 310   2 365   3 395   4 415   5 450   6 465   7     a) using the SIMPLE AVERAGE method to predict the demand for the 7th year b) the SIMPLE MOVING AVERAGE method to predict the demand for the 7th year

I Consider the demand for trading cards listed below. Month Demand Jan. 51,000 48,000 Feb. March 55,000 April May 58,000 66,000 June 69,000 80,000 July Aug. 95,000 Use Excel to prepare a forecast for September, October, and November using linear regression Print out the sheet of results, as well as a sheet containing the formulas that you used ( can be used to toggle between displaying values and displaying formulas or you can click on Formulas>Formula Auditing→Show Formulas.) and for the cars is 16.000

Mr. Jones sells scrapbooking materials. He charges $20 per album and sells 120 albums month at this price. He plans to decrease the price to generate more sales. A survey indicated that for every $0.50 decrease in price, he can expect to sell 5 more album s. a) Write the expressions for the price of an album and the number of albums sold in one month b) Write an equation for the revenue using your expressions from part a. c) What price will generate the maximum revenue?

The price of bauxiteincreased to its highest level due to conditions which impacted supply. Historically, bauxite has traded at between 1500 and 1600 USD per tonne. But the price increased to over 1900USD in November 2020. Growing demand in Canada for bauxite to be turned into aluminium, coupled with a sharp fall in Jamaican production have both been factors in the price increase. Bauxite production in Jamaica for 2017-18 fell 65% year-on-year due to flood conditions causing damages as well as increased competition. The London Metal Exchange predicts that global consumption of bauxite is likely to be greater than production by 20 million tonnes next year. In the US, companies in the steel and petrol industry have put pressure on the US government to relax import controls, warning that otherwise they might run out of bauxite. Commentators predict that most steel and petrol producers will be unaffected because bauxite is such a small part of their spending. a. Explain, using supply and…

In your company (electrical goods manufacturing), you want to forecast demand as well of a particular range of Smart TVs. Its monthly sales previous year, are presented in the table below: Month Sales January 400 February 650 March 1,150 April 1,700 May 500 June 900 July 1,150 August 1900 September 600 October 650 November 1,600 December 2050 Based on the above historical sales data: A) Create the corresponding graph and comment on the demand (sales) in terms of in trend, seasonality and periodicity please draw the diagram!!!!

Suppose the index of prices received by date farmers in Oman for 2008was 1.04 and the base year of index was 1999. Then, OPTIONS: (i) Relative to 1999, farm prices were 104% higher in 2008. (ii) Relative to 2008, farm prices were 4% higher in 1999. (iii) Relative to 2008, farm prices were 104% higher in 1999. (iv) Relative to 1999, farm prices were 4% higher in 2008.

Calculate the percentage change of the variable in each of the following cases. Then calculate the percentage change if the movement is occurring in the opposite direction, with what was the final value now the initial value and vice versa. Now calculate a comparable percentage change using the average of the initial and ending values. Express all three changes in absolute value form without positive or negative signs and as whole numbers (i.e. 67%, not 66.6%). a. A fast-food restaurant, which originally sold hamburgers at a price of $1, increases their price to $2. The absolute value of this percentage change is %, and the absolute value of the percentage change calculated using the average of the two values is 0.5 %, the absolute value of the percentage change in the opposite direction is | %. b. The number of autos sold monthly at a car dealership drops from 150 to 50. The absolute value of this percentage change is %, and the absolute value of the percentage change calculated using…

Calculate the percentage change of the variable in each of the following cases. Then calculate the percentage change if the movement is occurring in the opposite direction, with what was the final value now the initial value and vice versa. Now calculate a comparable percentage change using the average of the initial and ending values. Express all three changes in absolute value form without positive or negative signs and as whole numbers (i.e. 67%, not 66.6%). a. A fast-food restaurant, which originally sold hamburgers at a price of $5, increases their price to $6. The absolute value of this percentage change is %, and the absolute value of the percentage change calculated using the average of the two values is %, the absolute value of the percentage change in the opposite direction is %. b. The number of autos sold monthly at a car dealership drops from 400 to 300. The absolute value of this percentage change is %, the absolute value of the percentage change in the opposite direction…