Microsoft Project Assignment. MS Project 2013 Experience Required

/in /by

This assignment consists of two (2) parts: a project schedule, and a written response. You must submit both parts as separate files for the completion of this assignment. Label each file name according to the part of the assignment it is written for.

Part A: Project Schedule
(Submit as one [1] Microsoft Project file)

  1. Create a multi-level work breakdown structure (WBS) and detailed project schedule, using the information from the “Greendale Stadium Case” located at the end of Chapter 6, and incorporating the following constraints.
    Note: When you create your MS Project schedule, you will need to update your project per the following constraints:

    • The project must consist of at least twenty (20) tasks.
    • Each task must have a start and finish date that matches the duration noted in the assignment.
    • Each task must be assigned to a resource (e.g., Demolishing Crew; Construction Crew; Landscaping Crew).
    • Assume that the crew works during normal weekdays (no weekend work) under normal conditions (8 hours per day).
    • In terms of holidays, you can assume no work will be done the following days: New Year’s Day, President’s Day, Good Friday, Good Monday, Friday before Memorial Day, Memorial Day, the business day before Independence Day, Independence Day, the Friday before Labor Day, Labor Day, the day before Thanksgiving Day, Thanksgiving Day, Black Friday (day after Thanksgiving), the business day before Christmas, Christmas Day, the business day after Christmas Day, and New Year’s Eve.

Part B: Written Response
(Submit as a Microsoft Word file)

  1. Respond to the following questions in a one to two (1-2) page paper based on your project schedule.
    • When will the project be completed?
    • What is the critical path for the project?
    • How much slack / float is in your project? What activities have the greatest slack / float?
    • Identify the top three (3) activities that you believe could impact the project completion date.
    • What additional activities you would add to this project to make it more complete, from a project management viewpoint?

Greendale Stadium Case:

The G&E Company is preparing a bid to build the new 47,000 seat Greendale baseball stadium. The construction must start July 1, 2011, and be completed in time for the start of the 2014 season. A penalty clause of $100,000 per day of delay beyond May 20, 2014, is written into the contract.

Ben Keith, the president of the company, expressed optimism at obtaining the contract and revealed that the company could net as much as $2 million on the project. He also said that if they are successful, the prospects for future projects are quite good since there is a projected renaissance in building classic ball park with modern lluxury boxes.

Use Table 6.3 to construct a network schedule for the stadium project:

Image result for Greendale Stadium Case Table 6.3

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

3-2 Milestone One – ACC-201 – Financial Accounting

/in /by

Overview

In previous modules, you examined the initial stages of the accounting cycle and practiced journalizing financial transactions. In Milestone One, you will complete the first part of your course project to demonstrate your ability to accurately record financial data, which will continue to be used to complete other parts of the project.

Scenario

You are a certified public accountant (CPA) who is working with a small bakery to prepare their financial statements for three months of the current fiscal year. Because the company is a startup and so small, the accounting is done manually in Microsoft Excel. You have been given the accounts and information you need to prepare their financial statements, but you will need to use the accounting cycle to report accurate information to the finance department.

Prompt

Record Financial Data: Use accepted accounting principles to accurately capture business transactions for October, November, and December in the Company Accounting Workbook Template Spreadsheet using the data provided in the Accounting Data Appendix Word Document.

Specifically, you must address the following rubric criteria:

  • Accuracy: Prepare entries that are accurate in that they fully reflect the appropriate information.
  • Completeness: Prepare entries that are complete for each month, including transferring posted entries to T accounts.
  • Inventory Valuation: Prepare entries for the month of December to reflect the new line of products offered by the company, which includes using the entries from the “Inventory Valuation” tab to complete your journal for the month of December.

Guidelines for Submission

Using the provided template, submit your company accounting workbook with the following portions completed: October, November, and December journal entries; the “T Accounts” tab; and the “Inventory Valuation” tab. This should be completed and submitted using Microsoft Excel. Please note that there are drop-down menus embedded in the “Accounts” columns as well as formulas throughout the spreadsheet to help you complete the workbook without accidentally introducing errors.

Accounting Data Appendix

 

1. The following events occurred in October:

 

October 1: The business owner used $25,000 from their personal savings account to buy common stock in their company.

 

October 1: Purchased $8,500 worth of baking supplies from vendor, on account.

 

October 3: The company borrowed $10,000 in cash, in exchange for a two-year, 6% note payable. Interest and the principal are repayable at maturity.

 

October 7: Entered into a lease agreement for bakery space. The agreement is for one year. The rent is $1,500 per month; the last month’s rent payment of $1,500 is required at the time of the lease agreement. The payment was made in cash. Lease period is effective October 1 of this year through September 30 of the next.

 

October 10: Paid $375 to the county for a business license.

 

October 11: Purchased a cash register for $250 (deemed to be not material enough to qualify as depreciable equipment).

 

October 13: The owner has baking equipment, including an oven and mixer, which they have been using for their home-based business and will now start using in the bakery. You estimate that the equipment is currently worth $5,000, and you transfer the equipment into the business in exchange for additional common stock. The equipment has a five-year useful life.

 

October 13: Paid $200 for business cards and flyers to use for advertising.

 

October 14: Paid $300 for office supplies.

 

October 15: Hired a part-time helper to be paid $12 per hour. One pay period is the first of the month through the fifteenth, and the other is the sixteenth through the end of the month. Paydays are the twentieth for the first pay period and the fifth of the following month for the second pay period. (No entry required on this date—for informational purposes only.)

 

October 30: Received telephone bill for October in amount of $75. Payment is due on November 10.

 

October 31: Paid $1,200 for a 12-month insurance policy. Policy effective dates are November 1 through October 31.

 

October 31: Accrued wages earned for employee for period of October 16 through October 31. (See Wage Calculation Data table at the end of this document.)

 

October 31: Total October bakery sales were $15,000 ($5,000 of these sales on accounts receivable).

 

 

2. The following events occurred in November:

 

November 5: Paid employee for period ending October 31.

 

November 8: Received payments from customers toward accounts receivable in amount of $3,800.

 

November 10: Paid October telephone bill.

 

November 15: Purchased additional baking supplies in amount of $5,000 from vendor, on account.

 

November 15: Accrued wages earned for employee from period of November 1 through November 15. (See Wage Calculation Data table at the end of this document.)

 

November 15: Paid rent on bakery space.

 

November 18: Received payments from customers toward accounts receivable in amount of $1,000.

 

November 20: Paid $8,500 toward baking supplies vendor payable.

 

November 20: Paid employee for period ending November 15.

 

November 22: Purchased $300 in office supplies.

 

November 30: Received telephone bill for November in amount of $75. Payment is due on December 10.

 

November 30: Accrued wages earned for employee for period of November 16 through November 30. (See Wage Calculation Data table at the end of this document.)

 

November 30: November bakery sales total was $20,000 ($7,500 of this total on accounts receivable).

3. Many customers have been asking for more allergy-friendly products, so in December the bakery started carrying a line of gluten-free products on a trial basis. The information below relates to the purchase and sales of the new products.

 

Use the perpetual inventory method with the FIFO valuation method. Please see the “Inventory Valuation” tab in your workbook for purchase and sales information.

 

The following events occurred in December:

 

December 1: Paid dividends to self in amount of $10,000.

 

December 5: Paid employee for period ending November 30.

 

December 7: Purchased merchandise for resale. See the “Inventory Valuation” tab for details.

 

December 8: Received payments from customers toward accounts receivable in amount of $4,000.

 

December 10: Paid November telephone bill.

 

December 11: Purchased baking supplies in amount of $7,000 from vendor on account.

 

December 13: Paid on supplies vendor account in amount of $5,000.

 

December 15: Accrued employee wages for period of December 1 through December 15.

 

December 15: Paid rent on bakery space $1,500.

 

December 15: Recorded merchandise sales transaction. See the “Inventory Valuation” tab for details.

 

December 15: Recorded impact of sales transaction on COGS and the inventory asset. See the “Inventory Valuation” tab for details.

 

December 20: Paid employee for period ending December 15.

 

December 20: Purchased merchandise inventory for resale to customers. See the “Inventory Valuation” tab for details.

 

December 24: Recorded sales of merchandise to customers. See the “Inventory Valuation” tab for details.

 

December 24: Recorded impact of sales transaction on COGS and the inventory asset. See the “Inventory Valuation” tab for details.

 

December 30: Purchased merchandise inventory for resale to customers. See the “Inventory Valuation” tab for details.

 

December 31: Accrued employee wages for period of December 16 through December 31.

 

December 31: Total December bakery sales were $25,000 ($6,000 of these sales on accounts receivable).

 

4. On December 31, the following adjustments must be made:

 

· Depreciation of baking equipment transferred to company on October 13. Assume half month of depreciation in October using the straight-line method.

· Accrue interest for note payable. Assume a full month of interest for October. (6% annual interest on $10,000 loan)

· Record insurance used for the year.

· Actual baking supplies on hand as of December 31 are $1,100.

· Office supplies on hand as of December 31 are $50.

 

Wage Calculation Data

 

Month Hours Rate Pay
31-Oct 10 12 120
15-Nov 40 12 480
30-Nov 35 12 420
15-Dec 38 12 456
31-Dec 40 12 480
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Grader Project: Access Chapter 3 Capstone – Brilton Madley Games

/in /by

Follow the instructional steps to finish the project (point values can also be seen using the link below).

1. Start Access. Open the downloaded Access file named Exp19_Access_Ch03_Cap_Brilton_Madley_Games.accdb. Grader has automatically added your last name to the beginning of the filename.

2. Create a query using Query Design. From the Customers table, include the fields FirstName, LastName, and Phone (in that order). From the Orders table, include the fields OrderID, OrderDate, and ShippedDate (in that order). Run the query and then examine the records. Save the query as Shipping Efficiency.

3. Add a calculated field named DaysToShip to calculate the number of days taken to fill each order. (Hint: the expression will include the OrderDate and ShippedDate fields; the results will not contain negative numbers.) Run the query and then examine the results. Save the query.

4. Add criteria to limit the query results to include any order that took more than 30 days to ship.

5. Add the Quantity field from the Orders table and the ProductName field from the Products table to the query (in that order). Sort the query by ascending LastName.

6. Add the caption Days to Ship to the DaysToShip field. Switch to Datasheet view to view the final results. Save and close the query.

7. Create a query using Query Design and add the Customers, Orders, and Products tables. Add the Country field from the Customers table. Set the field’s Total row to Group By. Save the query as Revenue and Cost by Country.

8. Add a calculated field in the second column. Name the field TotalRevenue. This field should multiply the quantity ordered (from the Orders table) by the unit price for that item (from the Products table). Format the calculated field as Currency and change the caption to Total Revenue. Change the Total row for the TotalRevenue field to Sum.

9. Add a calculated field in the third column. Name the field TotalCost. The field should multiple the quantity ordered (from the Orders table) by the unit cost for that item (from the Products table). Format the calculated field as Currency and add a caption of Total Cost. Change the Total row to Sum. Run the query. Save the query. Return to Design view.

10. Add the OrderDate field and criteria to that field so that only orders made between 7/1/2018 and 12/31/2018 are displayed. Change the Total row to Where. This expression will display only orders that were completed during the second half of 2018. Run the query and view the results. Save and close the query.

11. Create a copy of the Revenue and Cost by Country query named Customer Payments. Switch to Design view of the new query and remove the Country, TotalCost, and OrderDate fields. Add the FirstName and LastName fields. Move the TotalRevenue field to the end. Rename the TotalRevenue field to OrderTotal. Change the caption to Order Total.

12. Add a new field using the Expression Builder named SamplePayment. Insert the Pmt function with the following parameters:
• Use .05/12 for the rate argument (5% interest, paid monthly)
• Use the number 12 for the num_periods argument (12 months)
• Use the calculated field OrderTotal for the present_value
• Use 0 for both future_value and type

13. Change the Total row to Expression for the SamplePayment field. Change the Format for the SamplePayment field to Currency. Run the query and verify the second order(with LastName Sparks) has a sample payment of $26.80. Note: it will display as a negative number. Save and close the query.

14. Create a copy of the Revenue and Cost by Country query named Revenue by Sales Rep. Switch to Design view of the new query and remove the entire Customers table, the TotalCost, and OrderDate fields. Add the Sales Reps table. Add the Title field from the Sales Reps table and move it to the front of the TotalRevenue field.

15. Run the query and then examine the summary records; there should be 4 Titles listed. Switch to Design view and change the sort order so that the title with the highest TotalRevenue is first and the title with the lowest TotalRevenue is last. Run the query and verify the results. Save and close the query.

16. Close all database objects. Close the database and then exit Access. Submit the database as directed.

Exp19_Access_Ch03_Cap – Brilton Madley Games 1.0

 

Project Description:

Brilton Madley, a board game manufacturer, hired a new CEO. She asked for your assistance in providing summaries of data that took place before she started with the company. To help her with her strategic planning, you will create queries to perform data analysis. Based on your meeting, you plan on creating four queries. One query will find orders with minor delays. Another query will summarize company revenue and cost by country. A third query will be used to help evaluate payments made by customers on their orders. The final query will calculate the total sales by sales representative title.

 

Steps to Perform:

Step Instructions Points Possible
1 Start Access. Open the downloaded Access file named Exp19_Access_Ch03_Cap_Brilton_Madley_Games.accdb. Grader has automatically added your last name to the beginning of the filename. 0
2 Create a query using Query Design. From the Customers table, include the fields FirstName, LastName, and Phone (in that order). From the Orders table, include the fields OrderID, OrderDate, and ShippedDate (in that order). Run the query and then examine the records. Save the query as Shipping Efficiency. 5
3 Add a calculated field named DaysToShip to calculate the number of days taken to fill each order. (Hint: the expression will include the OrderDate and ShippedDate fields; the results will not contain negative numbers.) Run the query and then examine the results. Save the query. 10
4 Add criteria to limit the query results to include any order that took more than 30 days to ship. 5
5 Add the Quantity field from the Orders table and the ProductName field from the Products table to the query (in that order). Sort the query by ascending LastName. 5
6 Add the caption Days to Ship to the DaysToShip field. Switch to Datasheet view to view the final results. Save and close the query. 5
7 Create a query using Query Design and add the Customers, Orders, and Products tables. Add the Country field from the Customers table. Set the field’s Total row to Group By. Save the query as Revenue and Cost by Country. 4
8 Add a calculated field in the second column. Name the field TotalRevenue. This field should multiply the quantity ordered (from the Orders table) by the unit price for that item (from the Products table). Format the calculated field as Currency and change the caption to Total Revenue. Change the Total row for the TotalRevenue field to Sum. 10
9 Add a calculated field in the third column. Name the field TotalCost. The field should multiple the quantity ordered (from the Orders table) by the unit cost for that item (from the Products table). Format the calculated field as Currency and add a caption of Total Cost. Change the Total row to Sum. Run the query. Save the query. Return to Design view. 11
10 Add the OrderDate field and criteria to that field so that only orders made between 7/1/2018 and 12/31/2018 are displayed. Change the Total row to Where. This expression will display only orders that were completed during the second half of 2018. Run the query and view the results. Save and close the query. 10
11 Create a copy of the Revenue and Cost by Country query named Customer Payments. Switch to Design view of the new query and remove the Country, TotalCost, and OrderDate fields. Add the FirstName and LastName fields. Move the TotalRevenue field to the end. Rename the TotalRevenue field to OrderTotal. Change the caption to Order Total. 5
12 Add a new field using the Expression Builder named SamplePayment. Insert the Pmt function with the following parameters: • Use .05/12 for the rate argument (5% interest, paid monthly) • Use the number 12 for the num_periods argument (12 months) • Use the calculated field OrderTotal for the present_value • Use 0 for both future_value and type 10
13 Change the Total row to Expression for the SamplePayment field. Change the Format for the SamplePayment field to Currency. Run the query and verify the second order(with LastName Sparks) has a sample payment of $26.80. Note: it will display as a negative number. Save and close the query. 10
14 Create a copy of the Revenue and Cost by Country query named Revenue by Sales Rep. Switch to Design view of the new query and remove the entire Customers table, the TotalCost, and OrderDate fields. Add the Sales Reps table. Add the Title field from the Sales Reps table and move it to the front of the TotalRevenue field. 5
15 Run the query and then examine the summary records; there should be 4 Titles listed. Switch to Design view and change the sort order so that the title with the highest TotalRevenue is first and the title with the lowest TotalRevenue is last. Run the query and verify the results. Save and close the query. 5
16 Close all database objects. Close the database and then exit Access. Submit the database as directed. 0
Total Points 100

Created On: 07/11/2019 1 Exp19_Access_Ch03_Cap – Brilton Madley Games 1.0

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

STATISTICS FOR DECISION MAKING

/in /by

Questionnaire

1) We are going to explore MEASURES of CENTER, which includes our Mean (aka Average), Median and Mode, and MEASURE of VARIABILITY, which includes Standard Deviation.

Respond to the following in a minimum of 175 words each question

· Discuss the concepts of Mean, Median, Mode, and Standard Deviation, including when each should be used, and evaluate the differences of each. (175 words)

· How can knowing this information about data help us? (175 words)

· Describe an example from your own personal or professional experiences about using either Measures of Center (mean, median, or mode) or standard deviation, and discuss how knowing that information helped you. (175 words)

 

2) Probability is about mathematically determining how likely an event is to happen. Probability can be applied to many different aspects of our lives and help us make informed decisions.

Respond to the following in a minimum of 175 words each question

· Discuss the concept of probability, including the notion of an experiment, outcomes, and sample space. (175 words)

· How can each of these be useful to us? (175 words)

· Describe an example from your own personal or professional experiences where you are focused on obtaining a specific, desired outcome. Evaluate what the ideal experiment, outcome, and sample space are for that situation.  (175 words)

 

3) When our data aligns to the characteristics of normal distribution, it maintains specific properties that help us interpret results and make decisions.

Respond to the following in a minimum of 175 words each question

· What is the normal distribution and the standard normal distribution? (175 words)

· What type (level) of data is being used in the standard deviation as distinguished from a binomial distribution (175 words)

· Discuss where the empirical rule applies. (175 words)

· How can you determine if the data follows a normal distribution? (175 words)

 

4) Hypothesis testing allows us to use an analytical process to determine if a hypothesis is retained OR rejected. This process compares a null hypothesis (HO), which states things as we believe they are, to an alternative hypothesis (HA), which proposes a change to what we believe exists.

Respond to the following in a minimum of 175 words each question

· Discuss the concepts of hypothesis testing, including what you are evaluating, (175 words)

· Explain when it should be used, previous concepts and the differences between a one- and a two-tailed test. (175 words)

· Describe an example from your own personal or professional experiences where you could apply a hypothesis test and discuss how knowing that information helped you. (175 words)

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"