PRG/420 Week 3

26 Overpayment. If line 23d is larger than the total of lines 22c and 24, enter amount overpaid

| if maritalStatus = ‘M’ taxRate = MARRIED_RATEif maritalStatus = ‘S’ taxRate = SINGLE_RATEif maritalStatus = ‘D’ taxRate = DIVORCED_RATEif maritalStatus = ‘W’ taxRate = WIDOWED_RATEIf hoursWorked <= 40 grossPay = hoursWorked * hourlyRateElse regularPay = (40 * hourlyRate) overtimePay = ((hoursWorked-40) * (hourlyRate * 1.5)) grossPay = regularPay + overtimePaytaxAmount = grossPay * taxRatenetPay = grossPay - taxAmount

In January, Reyes Tool & Dye requisitions raw materials for production as follows: Job 1 $960, Job 2 $1,630, Job 3 $720, and general factory use $680. During January, time tickets show that the factory labor of $6,100 was used as follows: Job 1 $1,570, Job 2 $1,940 Job 3 $1,670, and general factory use $920. Prepare the job cost sheets for each of the three jobs. (If answer is zero, please enter 0, do not leave any fields blank.) Job 1 Date 1/31 1/31 Direct Materials 960 0 Job 2 Date 1/31 1/31 Direct Materials 1630 0 Job 3 Date 1/31 1/31 Direct Materials 720 0 0 1670 Direct Labor 0 1,940 Direct Labor 0 1570 Direct Labor

I have project that the first-year revenue of $20,000 and a 15% growth rate for the next two years. The complete cost of sales is projected to average 50% of gross sales, including 40% for the purchase of equipment and 10% for the purchase of additional items. Net income is projected to reach $70,000 in four three as sales increase and operations become more

1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions:

28. cout << "The total amount is " << amount + tip + tax << endl;

Cost and Value management is becoming a large part of companies competing in today’s market. According to the text, “projects and their effective management can provide organizations with a significant competitive edge through cost reduction, enhanced responsiveness, and overall value to customers.” (Venkataraman & Pinto, 2008, p. 1). In this paper we are going to focus on some of the techniques and how they can either help or hinder a project. Through information and examples we will explore the importance of work packages and the work breakdown structure (WBS), establishing a cost and schedule performance

mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS Mincho"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} A clinic uses doctors and nurses to serve the maximum number of patients given a limited annual payroll. The clinic currently has 10 doctors and 30 nurses. The last doctor hired can serve 300 additional patients, while the last nurse hired can serve 200 additional patients. If doctors make $60,000 a year and nurses make

= (12,000 x $17) – (12,000 x $8) – (12,000 x $2) – $63,000 – $18,000

10,861.31 Salaries and Wages 12 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 Employee Related Expenses 15% 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 Direct Operatings Expesnes 3.60% 903 966 1,029 1,092 1,218 1,280 1,406 1,531 1,531 1,280 1,154 1,029 Utilities & Telephone 3.40% 853 913 972 1,031 1,151 1,209 1,327 1,446 1,446 1,209 1,090 972 Property Insurance 1.50% 376 403 429 455 508 533 586 638 638 533 481 429 Admin Expenses 1.70% 427 456 486 516 575 604 664 723 723 604 545 486 Repairs & Maint 1.00% 251 268 286 303 338 356 390 425 425 356 321 286 Advertising & Promotion 2.00% 502 537 572 607 677 711 781 851 851 711 641 572 Property & Related Taxes 2.20% 1,924 1,771 2,194 2,730 Inventory 532.20 44 44 44 44 44 44 44 44 44 44 44 44 Loan Pymt $1,836.20 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 Total Outflows: 25,550 24,518 25,411 28,075 28,106 28,981 32,961 32,552 32,552 31,712 27,196 25,411 Beginning Cash Balance 47,828 47,374 49,695 52,866 55,117 60,858 67,432

Stage 2 Mathematical Applications Interest minimisation on a Loan Occupation Josh Emma Occupation Social Worker Secondary Teacher Wages $1297 per week 1297 X 52 = $67444 per year $1424 per week 1424 X 52 = $74048 per year Tax amount $633,001 – $95,000 per year = $14,760 + $0.42 for each $1.00 over $63,000 67444 – 63000 = 4444 (4444 X .42) + 14760 = $16626.48 tax $633,001 – $95,000 per year = $14,760 + $0.42 for each $1.00 over $63,000 74048 – 63000 = 11048 (11048 X .42) + 14760 = $19400.16 tax Salary after tax 67444 – 16626.48 = $50817.52 after tax 74048 – 19400.16 = $54647.84 after tax Weekly budget of expenses for both Josh and Emma Expenses Price

If the finance department wanted to find the total compensation paid to each employee in the same month as the first query a slightly different query would be run to generate that information. The first code simply pulled the information and did not include and computation because the finance department only requested to be able to determine as in pull up the record for employee’s commission paid. The second code will include computation which will divide the yearly salary by twelve months then multiples the commission rate by the total amount of product sold and lastly add those two numbers together to get the total compensation for that month. Unfortunately the coding that I am using is not generating a proper result. However, it should look something like this:

| | | | | | | | | | | | | |75000 | |100000 | |125000 | |150000 | |175000 | |200000 | | |  | |  | |  | |  | |  | |  | |Direct Labor |4.00 |  |3.90 |  |3.80 |  |3.70 |  |3.80 |  |4.00 | |Material |2.00

The Problem Statement ................................................................................................................ 3 Demand Estimation ....................................................................................................................... 3 Cost Estimation ............................................................................................................................. 4 Price Method Proposal

Design a program that calculates the total amount of a meal purchased at a restaurant. The program should ask the user to enter the charge for the food, and then calculate the amount of a 15 percent tip and 7 percent sales tax. Display each of