Excel Exercise # 10 - Analyze Data_Hannon

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…

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.

Year 2018 Year 2019 Year 2017 [Tahun 2017] Price Product [Tahun 2018] Quantity [Kuantiti] [Tahum 20191 Quantity [Kuantiti] [Produk] Price Price Quantity [Kuantiti] (RM) [Harga (RM)] (RM) [Harga (RM)] 1 (RM) [Harga (RM)] 1.25 A 180 200 200 90 75 90 100 100 120 0.6 675 0.5 600 0.5 630 Compute the values of nominal GDP in 2017, 2018 and 2019. [Kirakan nilai-nilai KDNK nominal pada 2017, 2018 dan 2019] (i)

The two graphs attached show the relationship between the number of items sold per week vs number of weeks since the item arrived at the store.  Although both graphs show sales are increasing per week, the graphs look different. If you were the store manager, which item would you order more of during week 9 and why?

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. Also, advise your government on recommended interventions in the cigarette market.

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

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

Use #28 to answer question #29

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

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: Also, advise your government on recommended interventions in the cigarette market.

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.

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.

Please answer question number 4

Calculate e) and f) Thank you.

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…

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…

Please find the attached calculation question

#### Correct answer

Problem A large company in the communication and publishing industry has quantified the relationship between the price of one of its products and the demand for this product as: Price = 150 – 0.01 × Demand for an annual printing of this particular product. The company is planning its productions for the year 2021. The company is considering the production of a certain number of 2,000 pages units. In 2019 the company had produced 4 similar units but with fewer pages count per unit (1,200; 1,400; 1800; and 1,900), and the material costs associated with those 4 units are (14.15 JD, 15.65 JD, 18.25 JD, and 18.90 JD respectively). The material cost index values were 185 for 2018, 193 for 2019, 200 for 2020, and 206 for 2021. The fixed costs per year (i.e., per printing) = 50,000 JD, and the variable cost will consist of the material cost and the labor cost. The company started to produce 2000 pages unit in 2021, and the project management team observed that 8.23 labor hours were needed to…

Please answer question 11