{"id":19532,"date":"2021-12-01T03:55:22","date_gmt":"2021-12-01T03:55:22","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/ba-excel-modelling-operations-management-homework-help\/"},"modified":"2021-12-01T03:55:22","modified_gmt":"2021-12-01T03:55:22","slug":"ba-excel-modelling-operations-management-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/ba-excel-modelling-operations-management-homework-help\/","title":{"rendered":"Ba excel modelling | Operations Management homework help"},"content":{"rendered":"<div>\n<p>The Students&#8217; Union Shop is trying to work out how many cashiers it needs to employ in<\/p>\n<p>order to provide an adequate service level. Customers at the shop line up in a single queue<\/p>\n<p>and are called forward to pay for their purchases when a till becomes free. To help determine<\/p>\n<p>the busy times of the day, the shop has recorded the number of customers arriving at the tills<\/p>\n<p>in each 5-minute interval during the shop&#8217;s opening hours, from 8am until 6pm (N.B. this<\/p>\n<p>is the number who actually make a purchase and does not include customers who are just<\/p>\n<p>browsing). Records for a period of 5 weeks are available. All the data were collected during<\/p>\n<p>term time.<\/p>\n<p>The shop usually functions with just three cashiers but it has the capacity to support up to<\/p>\n<p>6. An extra cashier costs $20 an hour. The shop is open for approximately 50 weeks each<\/p>\n<p>year. The management has also collected data about the time it takes for cashiers to take<\/p>\n<p>payment. These data come from term time and 1000 records are available. Management are<\/p>\n<p>concerned that customers wishing to buy food, in particular, may be going to other outlets<\/p>\n<p>within the university such as the Big Ears Sandwich Shop or the Noddy Bar. Management are<\/p>\n<p>also concerned about the turnover of their sta and would like to reduce their stress and also<\/p>\n<p>stop them getting bored. They would be interested to hear about any innovative operating<\/p>\n<p>strategies for doing this.<\/p>\n<p>You have been employed as a consultant for the Students&#8217; Union Shop and should<\/p>\n<p> Report on their current business, pointing out any existing problems;<\/p>\n<p> Suggest improvements to their current strategies;<\/p>\n<p> Provide them with an ecient tool for easily evaluating their current performance using<\/p>\n<p>the data provided or new data in a similar format.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>The Students&#8217; Union Shop is trying to work out how many cashiers it needs to employ in order to provide an adequate service level. Customers at the shop line up in a single queue and are called forward to pay for their purchases when a till becomes free. To help determine the busy times of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-19532","post","type-post","status-publish","format-standard","hentry","category-homework-help"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/19532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=19532"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/19532\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=19532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=19532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=19532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}