MGMT570 (Spreadsheet Modeling and Simulation): Case 1 Sonoma Valley Wines Case Q1. Following table shows the optimal decision (within given constraints in the case) George need to make to maximize his profit: *Please refer to the excel file‚ “(Q1)” sheet‚ for more detail calculation. Amount Decision Variable Petite Sirah Sauvignon Blanc Total Wine Bottles to sell (year 1) 4‚469 6‚704 11‚173 Wine Bottles to sell (year 2) 62‚457 26‚767 89‚225 Spend on Grapes (year 1) $ 3‚575.42
Premium Cabernet Sauvignon Wine Fermentation
to estimate the machine overhead‚ administration ‚ marketing‚ shipping and commisiion cost 3. the machine overhead on attaching machine is 315 (= 4500 x 0.07) 4. Two-third of current R&D projects was related to fastener production. 5810 x 2/3 = 3873 6. sale of attching machine 7000 (=103‚000 - 96‚000) 7. since we have already known the general overhead on fastener‚ we can calculate the cost of sales‚ general and administration on attaching machine 70000-53285. The same calcuation method applied on
Premium Machine Mathematics Marketing
Introduction According to the forecasts‚ New Balance will be seeing growth for the next three years. Currently‚ the facility is too small for the desired production and the company needs to expand. The best location for expansion is Texas. Exponential Smoothing Forecast In exponential smoothing forecast‚ more weight is given to recent data. This type of forecasting is ideal for data with no seasonality. Seasonality‚ or regular changes in the data‚ is not seen for New Balance. The forecast includes
Premium Marketing Economics Revenue
INTRODUCTION Ford Motor Company was founded by Henry Ford in 1903‚ in Dearborn‚ Michigan. It is one of three leading automotive manufacturing companies in United Sates and grew to reach revenue of more than $144 billion with 370‚000 employees and operation spanned 200 countries. In the 1970’s‚ the automobile market for the major auto-makers‚ General Motors (GM)‚ Ford and Chrysler was crunched by competition from foreign manufacturers such as Toyota and Honda. The automakers faced the need to continue
Premium Supply chain management Automotive industry Supply chain
sales forecast ought to be based on clearly stated assumptions about future economic conditions. Next‚ they should prepare pro forma financial statements by either assuming that the key items vary proportionately with sales or remain constant (as the case may be). Based on their asset utilization rate‚ they would be able to determine the asset requirements for growth. Some of the funds required to finance growth would be raised from spontaneous sources such as accounts payables and accruals and from
Premium Balance sheet Generally Accepted Accounting Principles Revenue
Company X would like to have a method to be able to quantitatively analyze if there’s a business case for creating production cells in the factory. The company currently operates in a job shop based manufacturing environment in which similar machines are grouped into functional departments. This means that the parts are moved from department to department through the manufacturing process. The company currently does not have any production cells‚ neither have they identified products which together
Premium Management Manufacturing Strategic management
1. What kind of reinforces does Salatino use to motivate his sales people? Salatino uses every ones favorite reinforcements‚ money! Money is considered a secondary motivator because its not considered a basic human need. Saltaino uses commissions ranging between 5% and 12% as an incentive motivate his employees to make sales. This secondary motivator is a positive motivator because money is why people have jobs and careers. 2. What kind of reinforcement schedule is used by Great
Premium Reinforcement Harvard Business School Employment
And the firm willing to pay YSL’s normally billing rates. 2.0 Answer the question (a) The full cost of the Surenex engagement including indirect costs and direct costs. Direct costs consist of travel cost and cost of conducting surveys. In the case‚ direct cost means direct charge is about $3‚000. The professional compensation charges include partner $4‚800 and professional staff $4‚000. Each of engagement receives an allocation of overhead based on professional compensation charges. The data
Premium Costs Cost Variable cost
A literature review of Patients and Families experiences with video telehealth in rural/remote communities in Northern Canada. Rahul Raj Student id # 100806429 Course director: Diane Duff George Brown College‚ Toronto‚ Ontario Date of submission: March 02‚ 2012 Introduction The literature review critically valuates the families’ experiences with video telehealth in rural communities in Northern Canada. Many electronic health care research projects have tested the video
Premium Health care Health informatics Qualitative research
who tried the product found value in it. The target segment of the soap is women in the age group 18-35 years. The name “Sehra” is a headdress worn by grooms during weddings. Giving a masculine accessory’s name to a soap targeted at women is a case of incorrect positioning. The ad campaigns developed focused more on the Jasmine fragrance than the ‘purity’ aspect. Decision: “Sehra” should be launched nation-wide. Marketing Plan: Price: The purchase value as well as quantity increased when
Premium Marketing Product management