To vary your reporting, you decided to include graphical representation. Create a clustered column chart that shows the total amount each active customer with a data plan must pay. Format the total pay column to currency and give the chart an appropriate title. Remember to label the axes. (Hint: Create a query and export it to a spreadsheet application to create the chart.) Ensure that the chart is labelled appropriately and is placed on a new sheet. Name the Spreadsheet as MGMT2006_G#_<first name last name>. For example, MGMT2006_G50_ Jane Doe. CASE BACKGROUNDMGMT Mobile Company (MMC) offers mobile services to users on a monthlysubscription basis. Special discounts are given to customers for frequentlyusing their pre- or post-paid mobile service. Customers can also sign up onlineor visit one of ten outlets stationed at various locations around the country.https://tinyurl.com/b2n62ymcCustomers can opt to receive their bills either through the post oronline but all payments are due by the 21st of each month. An 18.5% mobile tax is applied to the cost of allservices. All transactions, customer calls and other data are captured in a database, where specific data canbe extracted for decision making.The company wishes to determine the types of customers who should be granted special offers and theamount of money received for taxes. The manager of MMC hired you to work in the Information SystemsDepartment to produce some reports for him to present at the meeting for the next quarter. He also wantsyou to focus mainly on the airtime usage to get a better understanding of the performance of the service.First, you need to peruse the database. It comprises the following tables:CUSTOMER: Persons who have an account with the company.SERVICE:The service offered to the customer is either PRE-PAID, POST-PAID, and the service comeswith or without a DATA PLAN.CALL:The duration of calls by the customer for the month, and the amount of data used for themonth.RATES:The rates for airtime usage, in cost per minute and the rates for data usage in cost permegabyte.You are asked to prepare several queries, as well as some reports.

Answered: Image /qna-images/answer/0809c550-a30c-4998-8efb-0bb390c891da.jpg

To vary your reporting, you decided to include graphical representation. Create a clustered column chart that shows the total amount each active customer with a data plan must pay. Format the total pay column to currency and give the chart an appropriate title. Remember to label the axes. (Hint: Create a query and export it to a spreadsheet application to create the chart.) Ensure that the chart is labelled appropriately and is placed on a new sheet. Name the Spreadsheet as MGMT2006_G#_. For example, MGMT2006_G50_ Jane Doe.

To vary your reporting, you decided to include graphical representation. Create a clustered column chart that shows the total amount each active customer with a data plan must pay. Format the total pay column to currency and give the chart an appropriate title. Remember to label the axes. (Hint: Create a query and export it to a spreadsheet application to create the chart.) Ensure that the chart is labelled appropriately and is placed on a new sheet. Name the Spreadsheet as MGMT2006_G#_. For example, MGMT2006_G50_ Jane Doe.

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Electronic Commerce And Enterprise Systems

Section: Chapter Questions

Problem 2WE

See similar textbooks

Similar questions

Q;- FOR HEALTH CARE CLIENT YOU ARE DESIGNING and developing a platform that caters to comprehensive medical care where patient data will be hosted on client-provider. The platform allows the patient to avail health services from doctors associated with one or more registered hospitals including online diagnostic services? WHICH OF THE FOLLOWING PII COLLECTED BY THE PLATFORM IS LIKELY TO BE OPTIONAL TO GET THE MDEICAL SERVICES 1.AGE 2.MOBILE NUMBER AND EMAIL ADDRESS 3. UNIQUE IDENTIFY SUCH AS NATIONAL IDNTITY INFORMATION 4. MEDICAL PRESCRIPTION
Q:2:-- YOU are developing an application that requires knowing the location of the user,in order to provide a service. IF a user doesn't want to let location data from smartphone be accessible. what is the design alternative to provide privacy by design perspective, for the user to avail the service 1. during APp installation obtain user permission to access loc data from smartphone 2. for the user who is not willing to share location data, deny application access. ( i think this one is right) 3.for the user who is not willing to provide loc data, provide an option for the user to key in an address 4. A and C
Mr Marcus Ng is a computer engineer who has recently developed an app which helps users keep track of medical information, doctor’s appointments, and prescriptions. Information about the useris stored in this app, including what prescriptions they are taking and how frequently they schedule doctor’s appointments. As the developers of the app, Mr Marcus and his company have access to this information.The marketing department requests Mr Marcus supply them with customer-specific information so they can better target ads and app suggestions to the users. Mr Marcus understands that he is part of a company, but also feels that the privacy of the app users should be protected. Additionally, Mr Marcus feels that as an engineer, he should be responsible to those who use his technology.How does Mr Marcus determine how much of the user’s information should be shared with marketing? Is this an ethical use of information or a violation of the user’s privacy?Elaborate your answer.
Issue a Request for Proposals (RFP) for the development of a mobile application for KFC that enables customers to place orders using their mobile devices.
Spotivity (https://www.spotivity.com) is a platform where teenagers, ages 13-17, and their parents can search and find extra-curricular programs for teens to participate in year round, whether it’s during summer vacation or just after school. The online platform was launched in May 2019 and features more than 3,000 activities available for teenagers in Chicago. The programs are available in several categories, including Sports, Education, Mentoring, Arts, Volunteerism, Health, and Jobs, Internships, and Camps. Spotivity is an only platform, offering access to afterschool programming. The owner had identified three user segments to target: teens, single parents, and high schools. Using 3Vs framework, explain how Spotovity creates value for the single parents segment.
Issue a Request for Proposals (RFP) for the development of a mobile application for KFC that enables customers to place orders via their mobile devices.
Based on a survey, In 2017, the IT Strategy team decided to develop a mobile application for the e-commerce store, and the firm launched the mobile app on 1st Jan 2018. Before 2018, smartphone visitors accessed the e-commerce store using the mobile website. Table 5 shows the average monthly visitors to the mobile website and mobile app from 2014 to 2019. (a) Write a formula in cell E15 to compute mobile website visitors' CAGR from 2014 to 2017. Screenshot attached below thank you
CASE BACKGROUNDMGMT Bakehouse Inc (MBI), supplies bread, cakes and other specialty products, to a large percentageof the country; to the following customer types. Retailers e.g. supermarkets, who sell baked goods to thepublic, and MGMT Bakehouse Inc delivers to the retailers. Wholesalers also sell to the public, but cometo MGMT Bakehouse Inc directly to collect their baked goods. Finally institutions like hotels andhospitals, to whom MGMT Bakehouse Inc delivers directly, buy baked goods to incorporate intooffering for their clients e.g. guests menus and patient meal plans.From the ordering of flour and other ingredients to the processing of cash, receivables and payables, thecompany uses an integrated ERP with a common database for all of its business processes. InternallyMGMT Bakehouse Inc is organized into the following departments: Production which bakes the bread;Distribution that delivers the bread; Sales Department where customer orders and wholesale pickups aremanaged; Marketing…
Case Description: Deb has recently launched her Rain Café in downtown Toronto. The Café is a blast. Customers cannot get enough of Deb’s coffee beverages and baked foods. To entice and retain customers, Deb is thinking of launching a loyalty membership app. She jots down what she has in mind of important features of the app. First and foremost, Deb wants an easy registration process for customers. In particular, a customer shall quickly create an account by simply entering his or her cell phone number. To ensure that the customer is the holder of the cell phone, the customer has to enter into the app a 6-digit confirmation code sent to the customer’s phone to complete the registration process. At the end of the customer registration process, the customer is provided a unique membership ID. Deb also wants to reward customers who refer their friends and family members to her café. A $5 voucher is added to the customer who has made a referral. So in creating an account, every new customer…
To keep up with demand, restaurants of all sizes need to provide solutions that letcustomers browse their menus, select options, and pay for their carryout or deliveryorders online. There are several online ordering systems for restaurants available inthe market that help you create a customized ordering experience on your restaurantwebsite or mobile app. They also allow restaurants to place QR codes around theirrestaurant for a contactless digital menu experience that takes diners to a restaurant’sonline ordering system. To help you in your search for the best solution for yourrestaurant, we have highlighted the top 11 online ordering system options to consider.One best system is called GEU ordering system. Customise your GEU orderingsystem by writing a PHP code for two partial web pages for ordering food from GEUonline store.✓ The first page you will write is a form named geuorder.php that allows the userto choose what kind of food to buy and how many to buy.o In your form, include a…
Applications which make use of blockchain technology are knawn as DApps. As developer for Elon's company, you are tasked with creating an easy to use Expense Tracker which saves data to the chain. Your friend wants to keep it as simple as possible to ensure that it's easy to pick up.Required features: User can input an expense Add new users Owner can Block/Unblock users Blocked users cannot post anything If the cost is more than 100 uint then that specific expense is marked as "Too expensive"; if less than 10 uint then it's marked as "Cheap". Mark when the latest expense was made (refer below) The name of the app can be updated by owner Read data: App name Show a user's most expensive expense Show a user's cheapest expense Total sum of a specific user's latest expense Count of how many expenses does a user have Get data on the most recent expense Show user info DATA: Expenses: id, category, amount, is it cheap, expensive, or not; date it was made User: id, address, totalExpense,…
Find-A-Helper System (FHS) is an online platform for connecting local domestic helpers and house cleaners to employers. Both employers and helpers must register profiles, which are then reviewed and approved by FHS consultants. Employer can request help by sending online request with his/her location. FHS will systematically allocate the request to the nearest available helper. Once the helper and the employer are connected and the service has been rendered, the employer will be requested to rate the helper. If the helper has ten 5-star rating in a month, he/she is awarded monthly price and will be put on FHS billboard.FHS has the following key features:1. Helper/Employer Registration - for signing up to become FHS user2. Profile review - for user screening3. Request-a-helper – This is used by employers to submit online requests for helper4. Helper-Rating – This is a rating mechanism, to ensure that hard working helpers arerecognized and awarded.Using Visual Studio tools complete the…