Virginia College promotes a wide variety of executive training courses for firms in the Arlington, Virginia, region. Director WendyTate believes that individually written letters add a personal touch to marketing. To prepare letters for mailing, she conducts a timestudy of her secretaries. On the basis of the observations shown in the following table, she wishes to develop a time standard forthe whole job.ElementCustomizing letterLabeling envelopeStuffing envelopeSealing, sortingPerformanceRating85%100%95%125%12.50.90.30.9Observation (minutes per cycle)42.10.70.30.923.50.80.43.032.80.62.0*0.852.73.2*0.54.3^63.30.60.61.0*Disregard-secretary stopped to answer the phone^ Disregard-interruption by supervisorThe college uses a total allowance factor of 12%. Tate decides to delete all unusual observations from the time study.The standard time for this process = minutes (round your responsedecim places).

Given data:Allowance Factor = 12%

Answered: Virginia College promotes a wide…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

The solution of coping with natural differences between marketing and production functions is to do what two things? Develop an equitable set of measurements and promote strong lines of communication Merge functional areas and improve forecasting Improve forecasting and maximizing productivity Appoint a single manager for both functions andproduce tosales forecasts Provide training on team techniques and coordinate reporting.
Develop a simple data model for a student data- base that includes student contact data, student demographic data, student grades data, and student financial data. Determine the data attributes that should be present in each table, and identify the primary key for each table. Develop a complete Entity Relationship diagram that shows how these tables are related to one another.
4, The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c. Complete the exponential smoothing forecast model for stock B. (Type integers or decimals rounded to two decimal places as needed.) Date Forecast B 09/03/2010 09/07/2010 enter your response here 09/08/2010 enter your response here 09/09/2010 enter your response here 09/10/2010 enter your response here 09/13/2010 enter your response here 09/14/2010 enter your response here 09/15/2010 enter your response here 09/16/2010 enter your response here 09/17/2010 enter your response here 09/20/2010 enter your response here 09/21/2010 enter your response here Date A B C D Stock Exchange 09/03/2010 127.07 18.54 20.84 15.44 10,536.56 09/07/2010 124.84 18.21 20.45 15.55 10,245.77 09/08/2010 125.67 17.77 20.83 15.72…
Problem 1 Forecasting • All analysis and calculations and report must be done in a single (ONE) Excel file.• Put your name at the top of the worksheet.• Make Excel do all of the calculations. (Instructor must be able to see your cell-reference formulas.)• Include report/answers below the forecasting calculations. o Make sure answers are clear, complete and easy to find. o Your report must include: a. Presentation of forecasts b. Explanation of why you chose each of the methods 1. Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years oftourist visits to the area. The following data has been gathered on number of tourists who signed into the localinformation center. Year Number of tourists1 7002 2483 6334 4585 14106 15887 16298 13019 145510 1989 Tom is interested in implementing a forecasting system and is…
A key factor for success for a retailer is a phenomenal forecasting process and resources (Jack Barker, 2015) because forecasting is a fundamental part of Spar Group Limited supply chain operations. To assist in leveraging this key factor, Spar Group Limited develop protocols forforecasting, and select a forecasting team with representatives from all the trading partners and stakeholders. Spar uses forecasting systems to provide a clear and actionable path for business activities, this helps the business to conquer certain market challenges (Graham O’Conner, 2018).Spar’s production forecast and scheduling process are broken down into two parts: planning, based on a monthly forecast, of assembly and components orders and daily scheduling of packaging custom products and sterilization based on finished goods inventory levels.During the fourth quarter of each fiscal year, Spar’s marketing and finance teams determine the annual forecast. The annual forecast is broken down based on…
A key factor for success for a retailer is a phenomenal forecasting process and resources (Jack Barker, 2015) because forecasting is a fundamental part of Spar Group Limited supply chain operations. To assist in leveraging this key factor, Spar Group Limited develop protocols forforecasting, and select a forecasting team with representatives from all the trading partners and stakeholders. Spar uses forecasting systems to provide a clear and actionable path for business activities, this helps the business to conquer certain market challenges (Graham O’Conner, 2018).Spar’s production forecast and scheduling process are broken down into two parts: planning, based on a monthly forecast, of assembly and components orders and daily scheduling of packaging custom products and sterilization based on finished goods inventory levels.During the fourth quarter of each fiscal year, Spar’s marketing and finance teams determine the annual forecast. The annual forecast is broken down based on…
A key factor for success for a retailer is a phenomenal forecasting process and resources (Jack Barker, 2015) because forecasting is a fundamental part of Spar Group Limited supply chain operations. To assist in leveraging this key factor, Spar Group Limited develop protocols forforecasting, and select a forecasting team with representatives from all the trading partners and stakeholders. Spar uses forecasting systems to provide a clear and actionable path for business activities, this helps the business to conquer certain market challenges (Graham O’Conner, 2018).Spar’s production forecast and scheduling process are broken down into two parts: planning, based on a monthly forecast, of assembly and components orders and daily scheduling of packaging custom products and sterilization based on finished goods inventory levels.During the fourth quarter of each fiscal year, Spar’s marketing and finance teams determine the annual forecast. The annual forecast is broken down based on…
What is educational about the article Wall Street Journal The Secret Oil-Trading Ring That Funds Russia’s War by by Joe Wallace? What is interesting about the article Wall Street Journal The Secret Oil-Trading Ring That Funds Russia’s War by by Joe Wallace? What is insightful about the article Wall Street Journal The Secret Oil-Trading Ring That Funds Russia’s War by by Joe Wallace? Article Link: The Secret Oil-Trading Ring That Funds Russia’s War -
Sales Planning and Forecasting: In a manufacturing & distribution company a. how often sales forecast is completed? b. how well is the sales-forecasting plan used in the day to day operations? c. what are some of the sales forecasting tools that could be used?
In the Stokely Company, marketing makes a sales forecast by developing a sales force composite. Meanwhile, operations makes a forecast of sales based on past data, trends, and seasonal components. The operations forecastusually turns out to be 20 percent less than the forecast of the marketing department. How should forecasting in this company be done?
Prepare a managerial report that help Moore Zales decide how to split the group of products being offered between an hour of peak and two hours of off-peak airtime in order to maximize the profits generated for the three hour line-up.
b) Use exponential smoothing with a smoothing constant of 0.30 to forecast the sales. Assume that last period’s forecast for month 1 is equal to actual to begin the procedure. b. Which method do you think is best? Is this an improvement over the weighted average- use MAD only ?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS