Quantitative Analysis For Business Management

Search for question

Questions & Answers

The Excel file HATCO consists of data related to predicting the level of business (Usage Level) obtained from a survey of purchasing managers of customers of an industrial supplier, HATCO. The following are the independent variables. • Delivery Speed-amount of time it takes to deliver the product once an order is confirmed.. Price Level-perceived level of price charged by product suppliers. • Price Flexibility-perceived willingness of HATCO representatives to negotiate price on all types of purchases. •Manufacturing Image-overall image of the manufacturer or supplier. . • Overall Service-overall level of service necessary for maintaining a satisfactory relationship between supplier and purchaser. • Sales Force Image -overall image of the manufacturer's sales force. • Product Quality-perceived level of quality of a particular product. . Size of Firm-size relative to others in this market (0=small; 1= large). Responses to the first seven variables were obtained using a graphic rating scale, where a 10-cm line was drawn between endpoints labeled "poor" and "excellent." Respondents indicated their perceptions using a mark on the line, which was measured from the left endpoint. The result was a scale from 0 to 10 rounded to one decimal place. Using the tools in this chapter, conduct a complete analysis to predict Usage Level. Be sure to investigate the impact of the categorical variable Size of Firm (coded as 0 for small firms and 1 for large firms) and possible interactions. Also stratify the data by firm size to account for any differences between small and large firms. Write up your results in a formal report to HATCO management. REQUIRED: Analysis of the excel data attached with formulas, calculations and graphs. And a report of the results.


The President's Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn during one month. 4 Room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. Guests staying for seven days or more receive a 10% discount. Modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay. Calculate the total sum of revenue from the bookings in the database.


The Microprocessor data shows the demand for one type of chip used in industrial equipment from a small manufacturer. . Construct a chart of the data. What appears to happen when a new chip is introduced? Develop a regression model to forecast demand that includes both time and the introduction of a new chip as explanatory variables. • What would the forecast be for the next month if a new chip is introduced? What would it be if a new chip is not introduced?


The 2016 Sales data contains customers' historical annual sales and their Christmas spend. Build a model to estimate upcoming Christmas spend based on their annual sales. Evaluate the goodness of fit; try to improve the model's fit to over 90%.


SAT is a standardized test for high school students. The SAT data is a study that examines the SAT and GPA information of 105 students who graduated from a university with a B.S. in computer science. As an advisor to the Admission Officer, you want to accept student applicants that have the high potential to excel in university. . Can you predict a student's college grades using the grades and test scores from high school? • What variables should or should not be included? Be sure to think about what variables are available at the time of application. Do not include if it is not available in highschool years. What is the final model? • What is the minimum requirement to get university GPA above 3?


d = 1,000 - 20p and p must be between $10 and $45 How many units can the firm sell at $10?


d = 1,000 - 20p and p must be between $10 and $45 How many units can the firm sell at $45?


d = 1,000 - 20p and p must be between $10 and $45 By how many units does a $1 increase in price decrease demand?


d = 1,000 -20p and p must be between $10 and $45 Which of the following pricing alternatives the business is considering maximizes revenue? A $20 B $25 C $30 D $40


The fixed cost is $240,000. Variable costs are $10 per book. Demand is estimated to be 6000 copies. The publisher plans to sell the book for $58 each. What is the breakeven point (copies of the book)?


The fixed cost is $240,000. Variable costs are $10 per book. Demand is estimated to be 6000 copies. The publisher plans to sell the book for $58 each. What profit or loss can be anticipated with a demand of 4,000 copies? (express profit as a positive number and loss as a negative number)


The fixed cost is $240,000. Variable costs are $10 per book. Demand is estimated to be 5000 copies. The publisher plans to sell the book for $58 each. What profit or loss can be anticipated with a demand of 6,000 copies? (express profit as a positive number and loss as a negative number)


The fixed cost is $240,000. Variable costs are $10 per book. Demand is estimated to be 6000 copies. The publisher plans to sell the book for $58 each. With a demand of 6,000 copies, what is the minimum price per copy the publisher must charge to break even?


The purchase price of the box is $350,000. The fixed construction cost is $5,000,000 and the variable construction cost is $100,000 What is the breakeven point (luxury boxes)?


The purchase price of the box is $350,000. The fixed construction cost is $5,000,000 and the variable construction cost is $100,000. What is the expected profit of building 30 luxury boxes?


The fixed construction cost of the luxury box is $5,000,000 and the variable construction cost is $100,000 With a demand for 25 luxury boxes, what is the minimum price per box the team must charge to break even?


Some venture capitalists learned in economics that total revenue is the total receipts a seller receives from selling goods to buyers, and that it can be written as P x Q, which is the price of goods times the quantity of goods sold. They hold the plans to the next "hot" technology gizmo that everyone will want to buy. In pricing the item, they made some assumptions: 1) For small quantities purchased, set the price low to invite people to get familiar with the product. 2) For large quantities purchased, set the price low as preferential treatment for your best customers. 3) Limit the number that can be purchased to a maximum of 1000 units. 4) An analyst recommends that the selling price for 500 units be $2500, or you will price yourself out of the market. They have hired you as a consultant to make a recommendation about what the maximum revenue will be for the company under this business plan. Even though the units may be sold in different quantities, the central question to ask is, "If all the purchases involved the same exact number of items, what would be the revenue for the company under that condition, and when would the revenue be as big as possible?" This would provide a ceiling figure to report back to the investors.


Happy Jack wants to capitalize on the health craze that is gaining momentum in the United States and introduce a new line of nutritious salads. Happy Jack is particularly cautious in launching new products and typically performs an extensive consumer acceptance test in several metropolitan areas before launching a new food product such as a salad line. Occasionally the company will take new food products directly to market without a consumer acceptance test, especially when the costs to do the consumer acceptance test are not warranted. The costs of such a test are usually about $2 million in total. The probability of a successful product launch is 0.70 when Happy Jack's consumer acceptance test results indicate that consumers like the product, and 0.20 when they have little to no interest in the product. When Happy Jack goes to market without a consumer acceptance test, the likelihood of a successful product launch is 0.25. Usually about 30 percent of products put through a consumer acceptance test are successful, according to historical data. To help Happy Jack make decisions on new product launches, they have created a new business analysis team. The supervisor of this new group, Harry Seitz, decides to assign you to this new product opportunity. Conducting a preliminary analysis, Harry concludes that the value to the Happy Jack, should the new salad line be successful, is approximately $25 Million over the life of the product. If the line is not successful, the company will likely lose $5 Million. This $5 Million would be in addition to the $2 Million for any consumer acceptance test. All product development costs are considered "sunk costs" and are not included in these calculations of product success or loss. Harry outlines the specific tasks that he wants you to complete. These specific tasks are outlined in Week 10 Assignment Sheet.


Your task is to provide recommendations concerning the optimal size of the new Riverside Stand. You have been provided an Excel file (called Ticket Sales.xlsx available on Moodle) showing the forecast for average number of tickets per game that could potentially be sold from 2022 to 2041. The demolition and building of the new stand will incur a fixed cost of £55 million. The fixed cost includes the construction of 3,000 seats (a minimum requirement), restaurants, meeting facilities, and bars. The owners have the option of further increasing the capacity. For every additional 1,000 seats, the variable cost is £3 million (e.g., a 7,000 seat stand would cost £67 million). The maximum allowable capacity of the new stand is 10,000 seats. Your clients have informed you that they are planning to draft a contract stipulating that 30% of the project's costs must be paid the day building works start (1 July 2022). A further 10% will be payable when work is completed (1 April 2024, just in time for the 2024 season). The remaining costs need to be paid in equal monthly payments at the end of each month during construction.


PART 1: BUCKEYE BUILDERS In the following problem, you will be analyzing the day to day operations of a new home building company named Buckeye Builders. One of your primary tasks will be to design an Excel workbook detailing the different model homes they offer, the various locations available in your new development, and the customer accounts you are currently handling. Development Specifications Your development area consists of 750,000 square meters of developable land. This development area already excludes the areas for roads and a lake. You will divide the land up into as many 1/4 acre plots as possible and build one of the model home types you offer on each plot. You may assume the development areas are sufficiently continuous such that all of the development area will contain plots; you do not need to deduct any area for streets and roads, etc. Now it is time to complete your analysis. 1. Based on the Total development area given in the Units worksheet, write an Excel formula in cell Units!D9 to calculate the number of Lake plots you will build per the allocation described in the Units worksheet. This formula should also work when you copy it down to determine the number of Center plots you will have and finally, the number of Road plots. (Use the ROUND function to round the number down to the nearest whole number.) 2. Write an Excel formula in cell Models!H3 to determine the base price for the Classic European home. This formula should also work when you copy it down to determine the base price for the New American Home, CSE Favorite, etc. Recall that the base price for each model depends on the number of levels and total square footage of the home. (S/SF for all combinations of stories) Square footage can be found in the Base worksheet. 3. Write an Excel formula in cell Customers!H5 to be copied down to determine the total value of the options purchased for the first customer's sale. When copied down, the formula will determine the total value of options for each corresponding customer. 4. Write an Excel formula in cell Customers!15 to be copied down to determine the Base price for the specific model home the first customer has purchased. When copied down, the formula will determine the total value of each home for the corresponding customer. (Do not use an IF function for this formula.) 5. Write an Excel formula in cell Customers!J5 to determine the location surcharge (not total cost), if applicable, for the home purchased by the first customer. Remember that the surcharge percentage is applied to the home price including options. Write the formula so that it can be copied down the column to determine the surcharge for each corresponding customer. (Do not use an IF function for this formula.) 6. Write an Excel formula in cell Customers!KS to be copied down to determine the total price of the home that the first person will purchase. Write the formula so that it can be copied down the column to determine the total home price for each corresponding customer. This should include options total, the base price and location charges. 7. In order to increase the number of customers who are purchasing the various options (Jacuzzi, basement walkout, larger plot, bay window in dining room), you have decided to offer an options package special for a limited time- Customers who purchase all of the options listed will get the highest priced option for free. Currently the larger plot is the most expensive option at $11,000 but keep in mind that prices are always subject to change. Write an Excel formula for cell Customers!L5, which can be copied down the column, to calculate the new total price of each home, taking into consideration any discounts for the options package, if applicable.


Factory produces whiteboard markers. The production process can be modelling by normal distribution with a mean length of 11 cm and a standard deviation of 0.25 cm. (a) What is the probability that a randomly selected whiteboard marker has a length longer than 10.5 cm? 100 whiteboard markers are randomly selected for quality checking. What are the mean and standard deviation of the sample mean length? What is the probability that the sample mean length will be between 10.99 cm and 11.01 cm? If 99.8% of the sample means are more than a specific length Y, find Y.


Discuss Abraham Maslow's hierarchy of needs theory and its managerial implications.


No Question Found forQuantitative Analysis For Business Management

we will make sure available to you as soon as possible.