PLEASE HELP CREATE IN EXCEL WITH STEP BY STEP. Fixed Interval Ordering 4. Create
ID: 379755 • Letter: P
Question
PLEASE HELP CREATE IN EXCEL WITH STEP BY STEP.
Fixed Interval Ordering 4. Create a spreadsheet called "Fixed Interval" and make a calculator that allows the user to enter the values in the bold boxes shown and computes annual demand, optimal order size and order cycle length. Hint: There is a helpful video that reminds you how to compute a Z value from a cumulative percentage under the standard normal curve 3 Daily demand . 4 StdDev of demand 5 Prod Days/y 6 Order Cost 7 Holding cost/unit/yr 8 Lead Time 260 10 Inventory 11 Service Lv 12 13 Annual demand 4 OrderSize 5 Order Cycle 23400 1200 12 5. Create a spreadsheet called "EPQ" and make a calculator that allows the user to enter the values in the bold boxes shown and computes the other values. 1 EPO 3 Demand per day 4 units produced per day s ProdDays 6 Setup Costs Holding Costs/unit/r 10 Total annual demand 23400 2389 12 EPQ 13 14 #prod runs per year 15 16 Max Inventory 17 18 Carrying Cost 9 Setup Cost 20 Total Inventory Costs 21 22 Prod Cycle 9.794893261 1958.98 2938.47 2938.467978 5876.937978 6. Be sure to fully close the Excel application after saving your file. Then submit your file to the dropbox and download it from the dropbox to 23 make sure that your downloaded file is readable in Excel. If you do not 24 Prod Run Time do fully complete this step, your assignment MAY be assigned a zero. 5 26.54444444 4.778Explanation / Answer
The media campaign will focus on encouraging riders to wear a helmet while riding a bike.
Target Audience:
The target audience will be primarily youth and young professionals. The age group of the target audience is about 18-35 years. The typical profile of the target audience is an unmarried youth of about 20-25 years old who uses his/her bike for daily commuting. He is relatively well off and is also quite passionate about his bike and enjoys long rides on the same.
Medium:
In order to target the personnel as per the target audience, the medium of choice is internet, email campaigns, streaming video on the internet and to a lesser extent radio also. He/She is less likely to have time to watch television and could most effectively engaged through content in social media, video on demand services and e-mails. So these mediums should be chosen for effective targeting.
Content:
The content of the ad campaign would showcase various incidents where neglect of helmet has resulted in fatalities in even minor incidents also. Also the audio visual would include events where helmets have turned out to be lie savior. Real life incidents of common people would be showcased for public to relate to them and spread the message.
Financing:
The financing of the campaign would be mostly from the government authorities and also the helmet manufacturers. A projection and dip stick study can be done to showcase the potential increase in complying with helmet rules post the campaign. The helmet manufacturers can be convinced to share some percentage of the incremental revenue arising out of the effects of the campaign.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.