AUPR Increasing Sales Restarutant Sales Questions
provide a graduate-level response to each of the following questions: You have recently been promoted to district manager …
AUPR Increasing Sales Restarutant Sales Questions
provide a graduate-level response to each of the following questions: You have recently been promoted to district manager of a large scale restaurant chain which specializes in affordable meals in a pleasant environment. In accordance with management objectives, you are responsible for increasing sales of appetizers by 20 percent by the next quarter for the 15 locations in your area. Keeping channel richness in mind, how will you make contact with the restaurant employees to facilitate the sales increase?
BPC 110 MC Guest Registration Worksheet
Can anyone look this over and give me assistance on the question and answer? I added the data but don’t understand the fo …
BPC 110 MC Guest Registration Worksheet
Can anyone look this over and give me assistance on the question and answer? I added the data but don’t understand the formulas and how to add those part to my sheets. There is a 2nd part related to access. Use Excel to create a workbook containing four worksheets. The Excel workbook will include hotel guest and reservation data, along with a chart, and the Rio Salado Hotel and Resort remodeling loans.Create a new blank workbookStructure of the WorkbookYour workbook must contain four worksheets:Guest Registration – This worksheet will contain guest contact information.Reservations – This worksheet will show the current room reservations for the Rio Salado Hotel and Resort.Income Chart – This worksheet will provide a visual depiction of the income of the current room reservations.Remodeling – This worksheet will contain contractor bids for the remodeling of the hotel.Guest Registration WorksheetThe Hotel and Resort wants you to create a new worksheet to keep track of their guests’ contact information:Rename the worksheet as Guest Registration.Assign the worksheet tab a color of your choice other than the Office default.Create a new table to store the following information for each guest (TIP: Remember to use fine data granularity):Guest NameGuest AddressPhone NumberEmail AddressGuest IDAlign Center and Bold the column headers of the table.Provide data in each cell of the table for a total of 10 guests using the following specifications:You provide the data for the Guest Names, Addresses, Phone Numbers, and Email Addresses.Use Special Formatting for the Phone Number column.Use Text and Concatenation Functions to generate each Guest ID using the first three letters of the Guest’s Last Name, and the Guest’s entire Zip Code.Increase the column widths to ensure that you can view the longest data entry in each cell of the worksheet.Align Left the Zip Code and Phone Number data.Sort Ascending the table on the Guest Last Name column.Apply an appropriate Table Style of your choice other than the Office default.Resolve any Error Messages you might receive in any cells.Freeze the column header row of the table.Use the Page Setup Dialog Box to perform the following tasks:Set the Page Orientation to Landscape.Scale to Fit to one page wide.Add a Footer to the worksheet:Enter your Name in the left section.Enter your MEID in the center section.Enter the Course Number and your Section Number in the right section.Reservations WorksheetAdd a new worksheet to keep track of the guests’ room reservations:Add a new blank worksheet to the workbook.Rename the worksheet as Reservations.Assign the worksheet tab a color of your choice other than the Office default.In the first row, insert the title Guest Reservations.In the second row, create a new table with the following column headers:Room NumberGuest IDCheck-In DateNumber of DaysCheck-Out DateRoom Rate per DaySubtotal of StayRoom TaxResort FeeTotal of StayVIP GuestMerge and Center the title in the first row over the table columns in the second row.Change the Font Size of the title to 18 pt.Apply a Fill Color of your choice, other than the default, to the title cell.Enter data in each cell of the table for 10 rooms using the following specifications:Room Number – Enter 10 different room numbers.Guest ID – Copy this data from the Guest Registration worksheet and Paste Values.Check-In Date – You provide this date. Use Short Date number formatting.Number of Days – You provide these values; between 1 and 7 days.Check-Out Date – Use a formula based upon the Check-In Date and Number of Days columns to calculate this date.Room Rate per Day – You provide these amounts; between $100.00 and $300.00. Use the appropriate number formatting.Subtotal of Stay – Use a formula based on the Number of Days and the Room Rate per Day columns to calculate this amount.Room Tax -A few rows below the table, enter a Row Label in Column A with the text “Room Tax”; in Column B of the same row, enter the value of 8.65%.In the Room Tax column of the table, use a formula to calculate the Room Tax based upon the Subtotal of Stay column and using an Absolute Cell Reference to the value of 8.65% that you entered in the previous step.Resort Fee -Below the Room Tax Row Label, enter a Row Label with the text “Resort Fee”; in Column B of the same row, enter the value of $24.99.In the Resort Fee column of the table, use an Absolute Cell Reference to equate all cells in the column to the value of $24.99 that you entered in the previous step.Total of Stay – Use a formula to calculate the total of stay based upon the Subtotal of Stay, Room Tax, and Resort Fee columns. Ensure that at least three (but not all) of the Total of Stay amounts is greater than $1,000.00 (adjust the number of days or room rates if necessary).VIP Guest – Use a Logical Function to display the text “YES” if the Total of Stay is greater than $1,000.00; otherwise, display “NO”.Increase the column widths to ensure that you can view the longest data entry in each cell of the worksheet.Using the Table Tools, add a Total Row to your table and use functions to Sum the Total of Stay column and Count only the number of VIP Guests.Apply the appropriate Number Formatting for all cells in your table.Use Conditional Formatting to apply Bold font style to the Top 2 Totals of Stay in your table.Apply an appropriate Table Style of your choice other than the Office default.Resolve any Error Messages you might receive in any cells.Freeze the first two rows of the worksheet.Use the Page Setup Dialog Box to perform the following tasks:Scale to Fit to one page wide by one page tall.Set the Page Orientation to Landscape.Add a Header to the worksheet:Enter your Name in the left section.Enter your MEID in the center section.Enter the Course Number and your Section Number in the right section.Income ChartThe Hotel and Resort CEO wants a visual depiction of the anticipated income from the reservations.Select the Reservations worksheet.Insert an appropriate chart using the data from the Room Number and Total of Stay columns.Using the Chart Tools, move the chart to a new sheet named Income Chart.Assign the worksheet tab a color of your choice other than the default.Select a Chart Style of your choice other than the default.Change the Chart Title to Anticipated Income.Add horizontal and vertical Axis Titles with appropriate text.Add Data Labels.Use the Page Setup Dialog Box to perform the following tasks:Set the Page Orientation to Landscape.Add a Footer to the worksheet:Use the Insert File Name button in the center section.Remodeling WorksheetThe owners of the Rio Salado Hotel and Resort want to remodel some of the rooms. Add a new worksheet to keep track of contractors’ bids and the amount of loans the owners would need to take out to pay for the remodeling.Add a new blank worksheet to the workbook.Rename the worksheet as Remodeling.Assign the worksheet tab a color of your choice other than the Office default.Create a new table with the following column headers:Contractor NameBidDown PaymentLoan AmountAnnual Interest RateTerm in YearsMonthly PaymentEnter data for a minimum of four contractors using the following specifications:Contractor Name – You will provide this information.Bid – You will decide this value and enter the amount.Down Payment – Use a formula with a cell reference to calculate a 10% cash down payment of the Bid.Loan Amount – Use a formula with cell references to calculate the amount that will need to be financed.Annual Interest Rate – Use the rate of 3.5% for all rows. Use the Increase Decimal button, if necessary, to show the entire rate.Term in Years – Use the value of 10 for all rows.Monthly Payment – Use an appropriate Financial Function to calculate the monthly payment.Increase the column widths to ensure that you can view the longest data entry in each cell of the worksheet.Apply the appropriate Number Formatting to all cells in your table.Apply an appropriate Table Style of your choice other than the Office default.Freeze the column header row of the table.Use the Page Setup Dialog Box to perform the following tasks:Set the Page Orientation to Landscape.Scale to Fit to one page wide by one page tall.Add a Header to the worksheet:Enter your Name in the left section.Enter your MEID in the center section.Use the Insert Date button in the right section.Required WorksheetsArrange the worksheets in the following order:Guest RegistrationReservationsIncome ChartRemodelingPart 2Structure of the DatabaseNOTE: Read the requirements for the database and be sure you understand how it should work before creating your design.You will need to complete the following to create your database:Create three tables.Import a table from Excel.Establish table relationships.Create two forms.Create two queries.Create one report.As you work on the project, remember to follow best practices for creating databases as described in your TestOut materials and the online lesson content.Create the TablesYou will create new tables that contain information about the Rio Salado Hotel and Resort room types and room rates. When creating fields for your tables, it is important to break down your data into the smallest chunks you can (fine data granularity) to make it easier to extract data from the database later. Remember to assign the most appropriate data type to each of the fields and that one of the fields in each of your tables must be set as the Primary Key using the AutoNumber data type. You do not need to enter data records into your tables at this time; you will create a form later in this project for data entry.Room Types TableCreate a new table named Room Types Table. At a minimum, your table should include the following fields:Type IDRoom TypeNumber of BedsMaximum OccupancyNumber of rooms (of this type)Room Rates TableCreate a new table named Room Rates Table. At a minimum, your table should include the following fields:Rates IDType IDRoom Rate DescriptionRoom RateEstablish Table RelationshipsOnce the design of the tables has been completed, the next step is to establish relationships between the tables. You will join the Room Types Table with the Room Rates Table on common fields through the following tasks:Join the primary key of the Room Types Table with the foreign key of the Room Rates Table in a One-To-Many relationship.Enforce referential integrity.Cascade update related fields.Cascade delete related records.Create a FormOnce the tables have been designed and the relationships have been established, it is time to enter data. Remember that each field of each record will need to include appropriate data. You will use one form to enter and edit data in the two tables:Create one form named Room Types Form that can be used to enter data into both tables.Change the title of the form to Room Types Form.Insert a row below the Room Rates Table subform. Add a button in the new row to perform the Add New Record action with the text: Add Record.Use the form to enter a minimum of four room types (e.g., Studio, Suite, 1-Bedroom, 2-Bedroom) and a minimum of three room rates and descriptions (e.g., Rack, Off-Season, Senior) for each room type. Include a Maximum Occupancy greater than 5 for at least two (but not all) room types.Apply the Retrospect theme to the form.Create a QueryThe ability to extract data from one or more tables is one of the most important functions provided by a database. You will now design, save, and run a query to show only the room types with a maximum occupancy greater than 5 by following these tasks:Create a query named High Occupancy Query based upon the Room Types Table.Include the Room Type and Maximum Occupancy fields.Use a Number Criteria for the Maximum Occupancy field to select only the room types with a Maximum Occupancy greater than 5.Save and run the query.Create a QueryNext, you will design, save, and run a query to show the total number of rooms in the Rio Salado Hotel and Resort:Create a query named Number of Rooms Query based upon the Room Types Table.Include the Number of Rooms field.Use the Total Row to Sum the number of rooms.Save and run the query.Create a TableYou will create a new table that contains information about the Rio Salado Hotel and Resort services. Remember to assign the most appropriate data type to each of the fields and that one of the fields in each of your tables must be set as the Primary Key using the AutoNumber data type. You do not need to enter data records into your tables at this time; you will create a form later in this project for data entry.Create a new table named Hotel Services Table. At a minimum, your table should include the following fields:Service IDService DescriptionOperating HoursPhone Extension NumberCreate a FormOnce the table has been designed, it is time to enter data. Remember that each field of each record will need to include appropriate data. You will use a form to enter and edit data in the Hotel Services Table:Create a form named Hotel Services Form that can be used to enter data into all fields of the Hotel Services Table.Change the title of the form to Hotel Services Form.Insert a row below the Phone Extension Number field. Add a button in the new row to perform the Add New Record action with the text: Add Record.Use the form to enter a minimum of four hotel services (e.g., Room Service, Housekeeping, Valet, etc.).Create a ReportReports are used to generate printouts from the tables in a database. The Report Wizard can be used to access multiple tables, select fields, and group data in a report:Use the Report Wizard to create a report named Hotel Services Report.Include the Service Description, Operating Hours, and Phone Extension Number fields from the Hotel Services Table.Group by Service Description.Use a Stepped Layout in Portrait Orientation and be sure the report fits on one page.After finishing the Report Wizard, remove the Alternate Row Color from the report.Add a Shape Fill of your choice, other than the Office Default, to the Service Description rows.Import a Table from ExcelOne of the best features of Access is how easily it can work with data from other programs. Since the Guest Registration information has already been stored in Excel, you need only to import the information in that spreadsheet into an Access table.Import the table from the Guest Registration worksheet created in Part 1 – Microsoft Excel as a new table named Guest Registration Table into your database.Your imported table must include Column Headings and a Primary Key.Assign the most appropriate data type to each of the fields.Edit Database PropertiesDatabase properties contain information on the title of the database, the author, and other information. Edit the database properties to include the following information:Go to the Backstage View by clicking on the File tab.Locate and edit the Database Properties to include the Course Number and your Section Number in the Subject field.Required ObjectsAfter creating your database, the RSC_Hotel_Database_MEID.accdb file should contain the following required objects:TablesGuest Registration TableHotel Services TableRoom Rates TableRoom Types TableQueriesHigh Occupancy QueryNumber of Rooms QueryFormsHotel Services FormRoom Types FormReportsHotel Services ReportSave and close your RSC_Hotel_Database_MEID.accdb database.
USE Recreational Facility Lease Agreement Discussion
You are the Athletic Director at Friends University, a public university located in Kansas. The president of the school ha …
USE Recreational Facility Lease Agreement Discussion
You are the Athletic Director at Friends University, a public university located in Kansas. The president of the school has pl you on a committee that will investigate the financial viability of a new recreation facility on campus. Moreover, because of your experience as athletic director, committee members have nominated you the chair of the committee. As chair, you will be the one presenting the committee findings to the president. How should the committee proceed? What costs will the president need to know about? What financial resources will be needed? What financial benefit(s) will the building have to Friends University and the surrounding community? What would the expenses look like for such a building? Note: a particular concern to Friends University is the growing student population and the increasing popularity of some of the intercollegiate athletic teams on campus, especially men’s and women’s basketball and volleyball. The campus currently has 10,000 full-time students, but the master plan projects 15,000 full-time students within the next 10 years. This recreation center must be constructed and financed in a manner that permits the recreation portion of the building to accommodate a growing student population. You have presented the committee findings to the president, and she would like to proceed with the new recreation center. The committee will now be tasked with hiring a new manager for the facility. How should the committee proceed? What would a job description look like for this position? What requirements and qualifications would a facility manager need to have? What type of questions should the committee ask potential candidates? Congratulations, the new recreation building is now built, and you have hired a manager to run it. As athletic director, you oversee all sport related contracts on campus. The local high school team would like to rent out part of the facility for a basketball tournament during Thanksgiving break. Your task is to write up a contract between Friends University and the local high school. What might this contract look like? Hint: I want to see a real contract.
Indiana Wesleyan University CH10 Impact of Health Information Technology Discussion
Read Chapter 10 of Basics of the U.S. Health Care System.Using the OCLS or the Internet, find an article discussing a curr …
Indiana Wesleyan University CH10 Impact of Health Information Technology Discussion
Read Chapter 10 of Basics of the U.S. Health Care System.Using the OCLS or the Internet, find an article discussing a current topic that is related to the assigned reading. The article can be from professional, scholarly, or popular media.The article must have been published within the last three (3) years.Navigate to the threaded discussion below and provide to the following:A short summary of the article.An explanation of how the article relates to the reading.Your thoughts on how the subject impacts the consumer/patient and provider relationship.A link to the article. Alternatively, you may post a copy of the article.Your initial response should be 150 to 200 words in length. Use proper spelling, grammar, and APA style. Include at least one citation from a credible source outside the textbook.The initial post must end in a question for your classmates to consider.
Week 11 Organizational Behavior Discussion
“Lessons learned” Please respond to the following:Watch the videos from Karl McDonnell, CEO of Strayer University, titled …
Week 11 Organizational Behavior Discussion
“Lessons learned” Please respond to the following:Watch the videos from Karl McDonnell, CEO of Strayer University, titled “What are some of the most important lessons you’ve learned in your professional career?” and “What advice do you have for our students who want to grow in their careers?” Discuss the most important lesson you’ve learned in your professional career and indicate how this lesson has helped to shape your career.****This is a discussion, NOT a paper. Need 2 strong paragraphs and references.***
Peyton Approved Financial Data: Preliminary Financial Statements have already been prepared (2017 statements in the Final Project Workbook). Final adjusting entries have not yet been made. See table for possible adjustments that indicate what will be rec
Overview: You just began a position as a financial accountant at Peyton Approved. In this role, your first task is to prep …
Peyton Approved Financial Data: Preliminary Financial Statements have already been prepared (2017 statements in the Final Project Workbook). Final adjusting entries have not yet been made. See table for possible adjustments that indicate what will be rec
Overview: You just began a position as a financial accountant at Peyton Approved. In this role, your first task is to prepare the company’s financials for the year-end audit. Additionally, the company is interested in expanding its business within the next year. They would like your support in assessing their ability to meet their goals. Refer to the data below and use the Final Project Workbook that includes the income statement, balance sheet, retained earnings statement and cash flow statement to complete the final project and associated milestones. Peyton Approved Financial Data: Preliminary Financial Statements have already been prepared (2017 statements in the Final Project Workbook).Final adjusting entries have not yet been made. See table for possible adjustments that indicate what will be recorded at 12/31/17 (fiscal year end). Use the following to complete year-to-year documentation and notes for managing depreciation, inventory, and long-term debt. A supplier shipped $3,000 of ingredients on 12/29/17. Peyton receives an invoice for $3,175 for the goods and freight of $175, all dated 12/29/17. Goods were shipped FOB supplier’s warehouse. At 12/31/17, Peyton has $200 worth of merchandise on consignment at Bruno’s House of Bacon. On 12/23/17, Peyton received $1,000 deposit from Pet Globe for product to be shipped by Peyton in the second week of January. On 12/03/2017, a mixer with a cost of $2,000, accumulated depreciation $1,200, was destroyed by a forklift. As of 12/23/17, insurance company has agreed to pay $700 in January, 2018, for accidental destruction. The company is planning to open another location in 2018. Using the Preliminary Statements as a base, prepare pro forma (budgeted) financials for 2018 for the new location using the following information: Cost of leasing commercial space: $1,500 per month. Cost of new equipment: $15,000, purchased with a long-term note. Use straight line depreciation assuming a seven-year life, no residual value. Use full year’s depreciation for the first year.Equipment purchase was financed with a long-term note. Cost of hiring and training new employees: three at $25,000 each for the first year. Except as noted in 1, 2, 3, and 5, assets, current liabilities, sales, costs, and expenses are expected to be 80% of the existing store (from preliminary statements) except no stock. Retained earnings = net income. Cash: $7,000. Accounts receivable amount to 4.0 turns (accounts receivable turnover will be 4.0); inventory amount to show 3.0 turns (inventory turnover will be 3.0). No stock will be issued. Retained earnings are to equal net income. Additional financing of $5,000 will be long-term. Add remaining amount needed to balance into accounts payable. For notes to the financial statements and Management Analysis Memo, consider the following: Peyton Approved uses the following accounting practices: Inventory: Periodic, LIFO for both baking and merchandiseEquipment: Straight line method used for equipment6% interest note payable was made on Jan 31, 2017, and is due Feb 1, 2019.5-year loan was made on June 1, 2016. Terms are 7.5% annual rate, interest only until due date.Insurance: Annual policy covers 12 months, purchased in February, covering March 2017 to February 2018. No monthly adjustments have been made. Business Financing Information: Use this information to calculate interest rates and insurance information, and to assess their impact on the company’s financial obligations:
- WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER
Why Choose Us?
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee

How It Works
- Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the “PAPER DETAILS” section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
About AcademicWritersBay.com
AcademicWritersBay.com is an easy-to-use and reliable service that is ready to assist you with your papers 24/7/ 365days a year. 99% of our customers are happy with their papers. Our team is efficient and will always tackle your essay needs comprehensively assuring you of excellent results. Feel free to ask them anything concerning your essay demands or Order.
AcademicWritersBay.com is a private company that offers academic support and assistance to students at all levels. Our mission is to provide proficient and high quality academic services to our highly esteemed clients. AcademicWritersBay.com is equipped with competent and proficient writers to tackle all types of your academic needs, and provide you with excellent results. Most of our writers are holders of master’s degrees or PhDs, which is an surety of excellent results to our clients. We provide assistance to students all over the world.
We provide high quality term papers, research papers, essays, proposals, theses and many others. At AcademicWritersBay.com, you can be sure of excellent grades in your assignments and final exams.