In a word document, in 300 words or more, describe how you would

Assignment 4 Instructions

Instructions:

Menu exercise

In this assignment, you must create a menu for XYZ Company’s Budgeting System. The system is a stand-alone application that uses a Visual Basic front-end and a SQL Server database on the back-end. The screens have already been designed, but the menu system has not yet been developed. The following background describes how the system should work.

·         Each budget consists of various scenarios (such as “Best Case,” “Worst Case,” “Most Likely,” etc.). The user can create as many scenarios as he desires, and it is up to him to manage the scenario (i.e., name it and assign its assumptions).

·         Each scenario consists of 20 assumptions (such as anticipated revenues, employee attrition, employee salaries, benefits, and various other expenses).

Although you do not need to understand the entire functionality of the system, you do need to know the various screens and features that have been developed. Note that the application opens with a main screen that contains a dashboard describing the number of scenarios that have been created, who created them, and the date on which they were created and last modified. Below is a list of features that the system performs and the type of implementation (i.e., separate screen, dialog box, etc.) for each feature.

1.      Create a new scenario – A separate screen is used to create a scenario.

2.      Open an existing scenario – An “Open File” dialog box allows the user to select which scenario to open. When the user selects a scenario from the dialog box, a separate screen opens that displays the scenario with all of its assumptions in a grid.

3.      Delete a scenario – A small screen opens that has a list of all the scenarios on it. When the user selects a scenario for deletion, he is prompted “Do you really want to delete this scenario? This action is not reversible.” If he answers “yes,” the scenario is permanently removed from the system.

4.      Rename a scenario – A small screen opens that has a list of all the scenarios on it. When the user selects a scenario to rename, he is prompted to enter the new name.

5.      Make a scenario the “Current Scenario”—A small screen opens that allows the user to select a scenario and make it the active scenario. Note that some actions can only be performed on the “Current Scenario.”

6.      Create an assumption – A separate screen is used to create an assumption.

7.      Edit existing assumptions – A dialog box allows the user to select which assumption to edit. When the user selects an assumption from the dialog box, a separate screen opens that displays the assumption with all of its properties in a grid.

8.      Delete assumptions – A small screen opens that has a list of all the assumptions on it. When the user selects an assumption for deletion, he is prompted “Do you really want to delete this assumption? This action is not reversible.” If he answers “yes,” the assumption is permanently removed from the system and all scenarios to which it is assigned.

9.      Add assumptions to the current scenario – A screen opens that lists all of the assumptions for the current scenario on the left side of the screen and all of the available assumptions on the right side of the screen. To add an assumption to a scenario, the user clicks one of the assumptions on the right side of the screen and drags it into the current scenario’s list of assumptions on the left side of the screen.

10.  Remove assumptions from the current scenario – A screen opens that lists of the assumptions for the current scenario in a grid, and the user can select which assumption he desires to remove from the current scenario.

11.  Save Current Scenario – This functionality should not open a separate screen, but rather save the “Current Scenario,” which writes to the database the mapping of all of the assumptions that have been assigned to the scenario.

12.  Save Assumption – This functionality is only available on the screen in which the assumption is being edited.

13.  Exit Application – This exits the entire application.

14.  Enter base values – This opens a screen that allows the user to enter baseline numbers (i.e., how many employees are currently employed, current salaries for employees, current tax rates, year-to-date balances in various expense accounts, etc.). These baseline numbers are used in the calculations for assumption projections.

15.  Run – This feature runs all of the calculations associated with the combination of assumptions for the current scenario. For example, an assumption that projects 20% attrition will multiply this rate times the baseline number of employees to determine the projected amount of attrition for the scenario.

16.  Add Years to the current scenario – Scenarios are defaulted to contain three years’ worth of projected data. If a user wants to extend his projections to four or five years, he can add years to a scenario. The user is issued a prompt that asks him how many years to include in the total projection for the scenario. New calculations are not performed. The user must “Run” his calculations to populate the newly added years.

17.  Produce reports for scenarios – Reports are used by management to determine various projected expenses for the current scenario. The following reports are available to be displayed. Note that these reports are displayed on the screen AND they should be able to be printed to a file or to a printer.

a.       Projected expenses by Product (table format)

b.      Projected expenses by Region (table format)

c.       Projected expenses by Employee type (table format)

d.      Projected expenses for the whole company (table format)

e.       Projected expenses by Product (chart format)

f.       Projected expenses by Region (chart format)

g.      Projected expenses by Employee type (chart format)

h.      Projected expenses for the whole company (chart format)

i.        Projected revenues by Product (table format)

j.        Projected revenues by Region (table format)

k.      Projected revenues by Employee type (table format)

l.        Projected revenues for the whole company (table format)

m.    Projected revenues by Product (chart format)

n.      Projected revenues by Region (chart format)

o.      Projected revenues by Employee type (chart format)

p.      Projected revenues for the whole company (chart format)

q.      Projected Profit/Loss Statement by Product (table format)

r.        Projected Profit/Loss Statement by Region (table format)

s.       Projected Profit/Loss Statement for the whole company (table format)

t.        Projected Profit/Loss Statement by Product (chart format)

u.      Projected Profit/Loss Statement by Region (chart format)

v.      Projected Profit/Loss Statement for the whole company (chart format)

w.    Assumptions for the scenario

18.  Compare Scenarios – A separate screen allows the user to select two or more scenarios to compare his assumptions. Another screen allows the user to select two or more scenarios to compare his profit/loss results.

19.  Administration of permissions – A separate screen is designed to allow administrative users to manage permissions of other users. This screen should only be visible to users who are designated as administrators of the system.

20.  Administration of Archives – A separate screen is designed to allow only administrative users to archive scenarios. The archiving functionality consists of several distinct features that are implemented on different screens:

a.       One screen is used to create a new archive and assign scenarios to it.

b.      A different screen is used to select an existing archive and retrieve a scenario from it for viewing.

c.       Baseline numbers from old scenarios can be imported into a new scenario. Therefore, a separate screen is used to open an existing archive for importing such numbers into the current scenario.

Deliverables:

1.      In a Word document, in 300 words or more, describe how you would implement a menu for this system. For example, would you use the same menu on the dashboard and on all of the different screens or a different menu on each screen? Would you use pop-up menus? Would you make all options on every menu available to all users?

2.       In the same Word document, draw mock-ups of how each menu will appear. You may use a drawing tool (such as Paint), a programming language (such as Visual Basic, which allows you to easily create menus), or even a hand-drawn picture that you scan into a Word document. You do not have to reproduce how you envision the screen to look – only the menus that appear on the screen(s). You may or may not decide to put a menu on each screen, but on whichever screens you desire a menu, draw a mock-up of that menu for that screen.

Calculate the price of your order

Select your paper details and see how much our professional writing services will cost.

We`ll send you the first draft for approval by at
Price: $36
  • Freebies
  • Format
  • Formatting (MLA, APA, Chicago, custom, etc.)
  • Title page & bibliography
  • 24/7 customer support
  • Amendments to your paper when they are needed
  • Chat with your writer
  • 275 word/double-spaced page
  • 12 point Arial/Times New Roman
  • Double, single, and custom spacing
  • We care about originality

    Our custom human-written papers from top essay writers are always free from plagiarism.

  • We protect your privacy

    Your data and payment info stay secured every time you get our help from an essay writer.

  • You control your money

    Your money is safe with us. If your plans change, you can get it sent back to your card.

How it works

  1. 1
    You give us the details
    Complete a brief order form to tell us what kind of paper you need.
  2. 2
    We find you a top writer
    One of the best experts in your discipline starts working on your essay.
  3. 3
    You get the paper done
    Enjoy writing that meets your demands and high academic standards!

Samples from our advanced writers

Check out some essay pieces from our best essay writers before your place an order. They will help you better understand what our service can do for you.

Get your own paper from top experts

Order now

Perks of our essay writing service

We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.

  • Swift delivery
    Our writing service can deliver your short and urgent papers in just 4 hours!
  • Professional touch
    We find you a pro writer who knows all the ins and outs of your subject.
  • Easy order placing/tracking
    Create a new order and check on its progress at any time in your dashboard.
  • Help with any kind of paper
    Need a PhD thesis, research project, or a two-page essay? For you, we can do it all.
  • Experts in 80+ subjects
    Our pro writers can help you with anything, from nursing to business studies.
  • Calculations and code
    We also do math, write code, and solve problems in 30+ STEM disciplines.

Frequently asked questions

Get instant answers to the questions that students ask most often.

See full FAQ
    See full FAQ

    Take your studies to the next level with our experienced specialists

    Chat
    Hello, my name is Derreck. Kindly drop your inquiry; I will get back to you shortly. (WhatsApp)+254 729 707 173