50.1K

Verified Solution

Link Copied!

marketing materials (brochure, flyer) will need to be printed how many coples due date Number of the brochure and flyer need to be kept in-stock at the office at all times How many copies of the brochure and flyer are in stock currently When printing supplies (ink, paper, etc.) will need to be purchased When large print jobs must be sent to the print/copy shop to ensure delivery of brochures or flyers when needed Amount planned to be spent on each supply order and/or print/copy shop order Total amount planned to be spent on printing in 2017 . . You have checked the printer supplies and found that the office has the following in-stock now: 1 unopened ream of paper (500 sheets) O unused ink/toner cartridges about 100 sheets of paper in the printer colour and black ink to print approximately 300 more pages Using this information, create a spreadsheet in Microsoft Excel to monitor the use of the business' printing resources in fulfilling its marketing needs. In this spreadsheet, include the following information: What marketing materials (brochure, flyer) will need to be printed, how many copies, and due date b. How many copies of the brochure and flyer need to be kept in-stock at the office at all times C How many copies of the brochure and flyer are in stock currently d. When printing supplies (ink, paper, etc.) will need to be purchased in the future to be able to produce marketing materials and satisfy general office needs on schedule When large print jobs must be sent to the print/copy shop to ensure delivery of brochures or flyers when needed f. Amount planned to be spent on each supply order and/or print/copy shop order E Total amount planned to be spent on printing in 2017 a e. D. November 2018: fall events fair on 11-13 October (1,000 brochures, 500 flyers) December 2018: "New Year New You" Event in Bahrain on 29-31 December (1,000 brochures, 600 flyers) Number of brochures and flyers in the office now: 85 and 50 E. Amount of general office printing expected: 500 pager per month Printing budget: Ms. All does not want to spend more than SAR COO in Buy one month on printing costs F. Printing instructions: do not print marketing materials more than one month in advance of their need because Ms. Ali may ask you to change or update them from time to time and any old copies loft in stock will need to be thrown out and wasted, G. Task 5 Ms. Ali has followed your advice and bought the printer you recommended. She also agreed with: your choice of print/copy shop. She has given you the following information about the business' marketing material needs for A. the rest Jof 2018 Number of brochures and flyers to have available in the office at all times: at least 100 of each Number of brochures and flyers regularly used each month: 100 of each Extra materials needed for upcoming special marketing events in 2018: March 2018: local wedding fair on 30-31 March (500 brochures, 250 flyers) ters) April 2018: trip to Riyadh on 9-11 April (100 brochures, 50 flyers) May 2018: major regional wedding fair on 13 May (2,000 brochures, 1,000 flyers) B. July August 2018: local partner business campaign (1,600 brochures, 600 flyers) September 2018: local family days celebration (1,000 October 2018: Johannesburg Photo Expo on 25-29 October (250 brochures, 50 flyers) C. ) marketing materials (brochure, flyer) will need to be printed how many coples due date Number of the brochure and flyer need to be kept in-stock at the office at all times How many copies of the brochure and flyer are in stock currently When printing supplies (ink, paper, etc.) will need to be purchased When large print jobs must be sent to the print/copy shop to ensure delivery of brochures or flyers when needed Amount planned to be spent on each supply order and/or print/copy shop order Total amount planned to be spent on printing in 2017 . . You have checked the printer supplies and found that the office has the following in-stock now: 1 unopened ream of paper (500 sheets) O unused ink/toner cartridges about 100 sheets of paper in the printer colour and black ink to print approximately 300 more pages Using this information, create a spreadsheet in Microsoft Excel to monitor the use of the business' printing resources in fulfilling its marketing needs. In this spreadsheet, include the following information: What marketing materials (brochure, flyer) will need to be printed, how many copies, and due date b. How many copies of the brochure and flyer need to be kept in-stock at the office at all times C How many copies of the brochure and flyer are in stock currently d. When printing supplies (ink, paper, etc.) will need to be purchased in the future to be able to produce marketing materials and satisfy general office needs on schedule When large print jobs must be sent to the print/copy shop to ensure delivery of brochures or flyers when needed f. Amount planned to be spent on each supply order and/or print/copy shop order E Total amount planned to be spent on printing in 2017 a e. D. November 2018: fall events fair on 11-13 October (1,000 brochures, 500 flyers) December 2018: "New Year New You" Event in Bahrain on 29-31 December (1,000 brochures, 600 flyers) Number of brochures and flyers in the office now: 85 and 50 E. Amount of general office printing expected: 500 pager per month Printing budget: Ms. All does not want to spend more than SAR COO in Buy one month on printing costs F. Printing instructions: do not print marketing materials more than one month in advance of their need because Ms. Ali may ask you to change or update them from time to time and any old copies loft in stock will need to be thrown out and wasted, G. Task 5 Ms. Ali has followed your advice and bought the printer you recommended. She also agreed with: your choice of print/copy shop. She has given you the following information about the business' marketing material needs for A. the rest Jof 2018 Number of brochures and flyers to have available in the office at all times: at least 100 of each Number of brochures and flyers regularly used each month: 100 of each Extra materials needed for upcoming special marketing events in 2018: March 2018: local wedding fair on 30-31 March (500 brochures, 250 flyers) ters) April 2018: trip to Riyadh on 9-11 April (100 brochures, 50 flyers) May 2018: major regional wedding fair on 13 May (2,000 brochures, 1,000 flyers) B. July August 2018: local partner business campaign (1,600 brochures, 600 flyers) September 2018: local family days celebration (1,000 October 2018: Johannesburg Photo Expo on 25-29 October (250 brochures, 50 flyers) C. )

Answer & Explanation Solved by verified expert

See Answer