Year George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows: O Season Winter Spring Summer Fall 1 1.480 1,520 1,000 640 2 1,240 1,400 2,140 810 3 1,000 1,640 2,040 690 4 900 1,580 1,960 520 George has forecasted that annual demand for his sailboats in year 5 will equal 6,500 sailboats. Based on the given data and using the seasonal model, the demand level for George's sailboats in the spring of year 5 will be sailboats (enter your final answer as a whole number and round all intermediate calculations to two decimal places).

Year George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows: O Season Winter Spring Summer Fall 1 1.480 1,520 1,000 640 2 1,240 1,400 2,140 810 3 1,000 1,640 2,040 690 4 900 1,580 1,960 520 George has forecasted that annual demand for his sailboats in year 5 will equal 6,500 sailboats. Based on the given data and using the seasonal model, the demand level for George's sailboats in the spring of year 5 will be sailboats (enter your final answer as a whole number and round all intermediate calculations to two decimal places).

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter11: Linear Optimization Models

Section: Chapter Questions

Problem 13P: The Silver Star Bicycle Company will manufacture both mens and womens models for its Easy-Pedal...

See similar textbooks

Similar questions

Osborne Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows: The data from the table are as follows: # of planters to be sold January: 3,400 February: 3,800 March: 3,300 April: 4,900 May: 4,600. Inventory at the start of the year was 850 planters. The desired inventory of planters at the end of each month in the upcoming year should be equal to 25% of the following month’s budgeted sales. Each planter requires three pounds of polypropylene (a type of plastic). The company wants to have 20% of the polypropylene required for next month’s production on hand at the end of each month. The polypropylene costs $0.20 per pound. Requirements Prepare a production budget for each month in the first quarter of the year,…
Hoffman Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows
Streeter Company produces plastic microwave turntables. Sales for the next year are expected to be 65,000 units in the first quarter, 72,000 units in the second quarter, 84,000 units in the third quarter, and 66,000 units in the fourth quarter. Streeter maintains a finished goods inventory at the end of each quarter equal to one half of the units expected to be sold in the next quarter. How many units should Streeter produce in the second quarter? Select one: a. 78,000 units b. 84,000 units c. 72,000 units d. 75,000 units
Nickel City Arcade is forecasting its sales for its peak summer season. One important part of the total sales amount is the daily admissions fees. Nickel City has a maximum capacity of 600 people per day. Each person pays an admission fee of $5. Here are the expected usage rates during the months of June, July, and August. June 30 days 50% July 31 days 70% August 31 days 40% What is the total forecasted amount of admissions fees for the months June through August? $161,100 $158,900 $132,700 $147,300
If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.
The Silver Star Bicycle Company will manufacture both mens and womens models for its Easy-Pedal bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 mens and 125 womens models to be shipped during the first month and 200 mens and 150 womens models to be shipped during the second month. Additional data are as follows: Last month, the company used a total of 1,000 hours of labor. The companys labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have at least 25 units of each model in inventory at the end of the two months. (Hint: Define variables for production and inventory held in each period for each product. Then use a constraint to define the relationship between these: inventory from end of previous period + produced this period demand this period = inventory at end of this period.) a. Establish a production schedule that minimizes production and inventory costs and satisfies the labor-smoothing, demand, and inventory requirements. What inventories will be maintained and what are the monthly labor requirements? b. If the company changed the constraints so that monthly labor increases and decreases could not exceed 50 hours, what would happen to the production schedule? How much will the cost increase? What would you recommend?
Lee Verly will be opening his company called LV Company in January of the next year. He predicts that January, February and March will generate $105,000, $140,000 and $105,000 worth of sales respectively. The company expects to sell 40% of its products for cash. 55% of the sales on account are expected to be collected in the month of the sale, 25% in the month following the sale and the remainder in the following month. Prepare the cash receipts section of the cash budget. Do not enter dollar signs or commas in the input boxes. Round your answers to the nearest whole number. LV Company Cash Receipts For January, February and March January Cash sales 42000 Collections from credit customers $34650 Total Cash Receipts 76650 February $56000 March ✓ $42000 x x
Bell Greenhouses has estimated its monthly demand for potting soil to be the following: Assume this trend factor is expected to remain stable in the foreseeable future. The following table contains the monthly seasonal adjustment factors, which have been estimated using actual sales data from the past five years: MONTH ADJUSTMENT FACTOR (%) March +2 June +15 August +10 December -12 Forecast Bell Greenhouses' demand for potting soil in March, June, August, and December 2007. If the following table shows the forecasted and actual potting soil sales by Bell Greenhouses for April in five different years, determine the seasonal adjustment factor to be used in making an April 2008 forecast. YEAR FORECAST ACTUAL 2007 500 515 2006 452 438 2005 404 420 2004 356 380
Havana Hats makes the world's best hats. Information for the last eight months follows: Month January February March April May June July August Number of Hats Produced 6,750 2,800 3,250 4,250 7,800 3,700 Intercept X Variable 1 6,150 6,800 r Suppose that Havana expects to sell 4,700 hats during the month of September and that each hat sells for $2.75. Havana performed a least-squares regression and obtained the following results: Total Cost $ 7,500 3,900 4,200 5,050 8,150 4,450 6,900 7,520 Coefficients 1,255.09 0.91 Contribution margin Required: Prepare Havana's contribution margin income statement for the month of September. Note: Round your answers to 2 decimal places. Havana Hats Contribution Margin Income Statement Month of September
You have been provided with monthly sales projections for year one for Maggie’s Coffee Café. Use these projections to answer the following: Based on the sales projections for Maggie’s Coffee Cafe determine: Sales per day for the first month they are open (January) ______________ Sales per day for the 6th month they are open (June) ______________ Sales per day for the 12th month they are open (December) ______________ (assume the business is open 7 days/week; Jan and Dec have 31 days; June has 30) Which month has the highest sales? Which month has the lowest sales? Why do you think this is so?
Global Lawn, a manufacturer of lawn mowers, predicts that it will purchase 228,000 spark plugs next year. Global Lawn estimates that 19,000 spark plugs will be required each month. A supplier quotes a price of $11.00 per spark plug. The supplier also offers a special discount option: If all 228,000 spark plugs are purchased at the start of the year, a discount of 4% off the $11.00 price will be given. Global Lawn can invest its cash at 10% per year. It costs Global Lawn $260 to place each purchase order. Read the requirements. Requireme Let's begin t Differer Requirements 1. What is the opportunity cost of interest forgone from purchasing all 228,000 units at the start of the year instead of in 12 monthly purchases of 19,000 units per order? C---- 2. Would this opportunity cost be recorded in the accounting system? Why? 3. Should Global Lawn purchase 228,000 units at the start of the year or 19,000 units each month? Show your calculations. 4. What other factors should Global Lawn…
Donaldson Bed and Breakfast has six available rooms to rent to tourists visiting Niagara Falls. Guests enjoy a comfortably appointed room with an attached bathroom and the owners provide a hearty breakfast each morning. The owners have calculated that their typical occupancy rate is 80% per month. The cost to rent each room is $65 per occupied room per day assuming a 30-day month. Some of this cost is fixed and some variable. During the month of June, the occupancy rate went down to 60% and the total cost to operate that month was $7, 650. Required: 1. Using the high-low method, estimate the variable and fixed cost elements of the bed and breakfast's operation in a typical month. Note: Do not round your intermediate calculations. Round the "Variable cost per room" to 2 decimal places. Average # room nights rented per month Total Monthly Cost High level of activity Low level of activity Change Variable cost per room Fixed cost per year 2. Express the variable and fixed costs in the form…