Show computation. Use IF function and applicable logical functions based on the Policy Table. Test Instructions1. Determine the Marketing Budget of each location using the Marketing Budget PolicyTableMarketing Budget Policy TableO to 300,000 population, buget is 5 pesos per personmore than 300,000 to 600,000, budget is 7 pesos per personmore than 600,000 to 1,000,000, budget is 10 pesos per personmore than 1,000,000, budget is 12 pesos per personLocationPopulationMarketing BudgetQuezon City2,761,720Makati510,383Mandaluyong305,576Pasig617,301Caloocan1,500,000Manila1,600,000Pasay416,522Taguig644,473Pateros63,840Muntinlupa452,493Malabon380,522Navotas249,463Las Pinas590,000Paranaque552,660San Juan121,430Marikina424,610Valenzuela568,928

Location Population Marketing Budget Quezon City 27,61,720 33140640 Makati 5,10,383 3572681…

Answered: 1. Determine the Marketing Budget of…

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter4: Financial Functions, Data Tables, And Amortization Schedules

Section: Chapter Questions

Problem 6EYK

See similar textbooks

Similar questions

Steps to create an initial budget sheet in Excel for your event: Open a new Excel workbook and create a new sheet for your budget. Name the sheet something like "Event Budget" or "Initial Budget". In the first column, list the five areas/tasks where you will spend the budget. For example, your list could be: Venue rental Catering Entertainment Decorations Staffing In the second column, list the amount you plan to spend on each area/task for each day of the event (Day 1, Day 2, and Day 3). For example, your list could be: Venue rental: $(Enter amount) per day Catering: $(Enter amount) per day Entertainment: $(Enter amount) per day Decorations: $(Enter amount) per day Staffing: $(Enter amount) per day In the third column, use a formula to calculate the total amount you will spend on each area/task over the three days. For example, if you plan to spend $5,000 on venue rental each day, the formula would be "=5,000*3" to calculate the total amount of $15,000. Repeat this formula…
Table: Team Member Primary key: Team MemberID Team MemberID 1 2 3 Table: Task Primary key: TaskID Foreign key: Team MemberlD TaskID 1 2 3 Team MemberName Joe Bloggs Samantha Smith Pete Ngwenya Description Build login screen 4 Implement inventory 10 management Add logo to splahs 1 screen Duration TaskID 4 Description Implement email Team MemberEmail joe@theoffice.com sam@theoffice.com pete@theoffice.com Q.6.2.1 Write a SQL statement to create the table Task. StartDate 2022-05-06 1 2022-05-15 1 2 TeamMemberID Hint: The sample data should give you an indication of the data types you should use. Q.6.2.2 Write a SQL statement that will add the below row to the Task table. Duration StartDate Team MemberID 2022-05-07 3 2022-05-06 2 notifications Q.6.2.3 Write a SQL statement that will change the value of the Task description with ID 3 to "Add logo to splash screen".
Q.6.3.4 Write a SQL statement to get a list of the tasks in the database, arranged by duration from largest to smallest. Include all the columns from the Task table. Q.6.3.5 Write a SQL statement to get the total duration of all the tasks that start between 2022-05-01 and 2022-05-31 (both inclusive).
Draw a activity Diagram: Actors Use Cases Use Case Description Customer Login Tesco appointment website Customer must login Tesco website and choose the appointment tab to start. Choose Tesco Branch Location Customer will have to choose a Tesco branch of their choice. Fill in personal information Customer will have to input name, phone number or email and ID verification View available date and time slots Customer must look at available dates and time Tesco currently offers Select date and time slot Customer will have to choose date and time of their choice subject to availability at Tesco. Receive confirmation with QR code Customer will receive confirmation of appointment along with QR code to present to Tesco clerk. Appointment System Verify customer’s phone number or email System will cross-check if the customer registered with a legit number or email by sending OTP. Generate QR code for booking System will generate…
Question: Conference Registration System Create an application that calculates the registration fees for a conference. The general conference registration fee is $895 per person. There is also an optional opening night dinner with a keynote address for $30 per person. Additionally, the optional preconference workshops listed in the table 1 below are available. Table 1: Optional preconference workshops Workshop Introduction to E-commerce The Future of the Web Advanced Visual Basic Network Security Free $295 $295 $395 $395 The application should have two forms. The main activity should appear similar to the one shown in Figure A.
Format the range K2:K3 with Accounting Number Format with zero decimal places. Format cell K4 with Comma Style with zero decimal places. You want to use the FORMULATEXT function to display the functions. In cell G2, insert the FORMULATEXT function to display the formula stored in cell B3. In cell G3, insert the FORMULATEXT function to display the formula stored in cell B4. In cell G4, insert the FORMULATEXT function to display the formula stored in celI D8. In cell G5, insert the FORMULATEXT function to display the formula stored in cell K2.
How does the proposal change in content, depending upon your audience (i.e., technical, financial, managerial, etc.)?
The Bright Light Academy The Bright Light Academy is a high school that is located in Midrand. The school opened its doors for enrolment of students in 2018. They enrol from Grade R to Grade 12. As of the last quarter of 2020, the school’s enrolment has grown tremendously to 400 students and they are anticipating that their enrolment will increase further. Since its inception, the school has been using Pastel Accounting to administer its finances. The school board of trustees has made a decision to develop an in-house integrated school management system. The school is hoping that the system will help in its blended learning strategy in the beginning of the second quarter of 2021. Source: Maodza, B. (2021)Question 4You have been hired as the Lead Architect of the school. Model a detailed use case diagram for the proposed integrated school management system.
When you create a new job category – Select one: a. all employees are assigned to the new category initially b. no employees are assigned to new category initially c. all employees in this category are not salespersons initially d. you cannot assign an employee from another category to the new category at the same time.
Your manager wants you to create a 6-8 slide PowerPoint presentation outlining the company’s new product launch. For this assignment, select an existing company or create your own fictitious company name. Come up with a new product the company will launch. Examples of a new product could be a new smart watch, cell phone, breakfast cereal, home improvement idea, kitchen appliance, etc. The choice is up to you. Make sure your PowerPoint presentation incorporates the following best practices: Create or select a template. Content. No more than 30 words on each slide. Font size should be 24 or less. No more than 6 lines of text per slide. Write your content with your audience in mind. Key points and use phrases instead of full sentences. Use the notes section below each slide to write out the details of what you would have said had you given the presentation live. Slides. Include a title slide and a conclusion/summary slide. Fonts and colors. Try not to use more than three fonts. Make…
Create source selection criteria that might be used for evaluating 3 proposals for providing laptops for all students, faculty, and staff at a University. Include at least 5 criteria, and make the total weights add up to 100. Explain the criteria and their weights.
Create an organisational chart with at least 15 employees. The chart should display at least 4 levels. Be sure to include the title/role of each person.

SEE MORE QUESTIONS

Recommended textbooks for you

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:

9780357392676

Author:

FREUND, Steven

Publisher:

CENGAGE L

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:

9780357392676

Author:

FREUND, Steven

Publisher:

CENGAGE L

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS