Payroll math worksheets

Unit II Assignment Instructions: This assignment involves solving four problems that allow you to calculate markups and markdowns. This assignment provides you with an opportunity to demonstrate the following learning outcomes: 1. Calculate the cost and selling price of merchandise based on mark-up and mark-downs using algebraic formulas and percentages. 1.1 Use the formula for calculating the markup on a product’s cost. 1.2 Use the formula for calculating the markup on a product’s selling price. 1.3 Calculate the markdown based on a product’s original selling price. Save all of your work to this template and submit it in Blackboard for grading. 1. For the following problem, find the amount of markup and the percent markup “on cost.” In the space below the table, be sure to show all of your work. Insert the final answers into the table. Cost Price Markup % Markup on Cost Selling Price $82.88 $151.19 (Round your answer for % Markup on Cost to the nearest whole number.) 2. For the following problem, solve for the missing numbers (i.e., a, b, and c). Markup is based “on selling price.” Round dollar amounts to the nearest cent. In the space below the table, be sure to show all of your work. Insert the final answers into the table. a Cost price b 25% Markup $5.00 100% Selling price (Round to the nearest cent, if necessary.) c 3. For the following problem, find the percent of markdown and the reduced price. In the space below the table, show all of your work for calculating the answers. Insert the final answers into the table. Original Price % Markdown $ Markdown Reduced Price $820 $234 (Round your answer for % Markdown to the nearest whole percent as needed.) Page 1 of 2 4. The following problem shows the original price and the markdown of an item for sale in Japan. Find the percent of markdown and the reduced price by expressing your answers in both Yen and dollars (1 dollar = 117.58 Yen). In the space below the table, show all of your work before indicating the correct answers in the table. Original Price $7.60 % Markdown $ Markdown Reduced Price $2.10 ¥ 893.62 ¥ 246.92 (Round your answer for % Markdown to the nearest whole percent as needed.) Page 2 of 2 Unit III Assignment Instructions: This assignment involves completing two exercises that allow you to analyze trends by creating a graph that is based on data from a table. This assignment provides you with an opportunity to demonstrate the following course learning outcome: 3. Analyze methods to maintain necessary profit and competitive selling strategies, while controlling expenses via associative formulas and breakeven analysis. Save all of your work to this template and submit it in Blackboard for grading. Exercise 1. This exercise involves using the data within a table to construct a line graph for the Acme Corporation. The table below shows total sales as well as total expenses between January and June. To visually analyze the trend of this data, you are going to create a double line graph. Total Sales in Millions Total Expenses in Millions Jan. $134 $98 Feb. $122 $97 Mar. $112 $15 Apr. $135 $67 May $156 $90 Jun. $167 $76 Insert your line graph in the space below. Exercise 2. This exercise involves analyzing the data on the graph in Exercise 1, and then drawing a conclusion based on the “trend” that the graph demonstrates. With at least 100 words, describe the type of trend that might be occurring in your line graph for Exercise 1. Page 1 of 1 Unit VII Assignment This assignment involves solving six problems that include calculating payroll costs, reconstructing a budget, and calculating turnover. Each of the problems require you to show your work. This assignment provides you with an opportunity to demonstrate the following learning outcomes: 6. Examine business arithmetic operations for payroll and turnover. 6.1 Calculate the gross earnings with and without overtime for an employee. 6.2 Calculate the net pay for an employee by subtracting appropriate deductions. 6.3 Utilize various methods of calculating gross earnings. 8. Reconstruct a budget containing performance reports, to verify accurate expenditures on individual business functions. 8.1 Apply corrections to an existing budget. 8.2 Assess the accuracy of expenditures and the associated calculations on a budget sheet. Save all of your work to this template before submitting it in Blackboard for grading. 1. Determine the earnings for the employee. Hours in excess of 40 are overtime hours. Insert your final answers into the appropriate cell of the table. Plus remember to show your work below the table. Name S M T W Th F S Burns, J. 8.7 8.1 8.9 8.9 8.6 7.8 Regular Hours Overtime Hours Regular Rate $8.48 Overtime Rate $12.72 2. Andy Tresor assembles switches. He is paid $1.16 for the first 519 units assembled in a week and oneand-a-half times the regular rate for ‘overtime’ units. Andy’s production for the week of November 17th is shown below. Insert your final answers into the appropriate cell of the table. Plus, be sure to show your work below the table. Units Produced Regular hours Overtime hours 519 28 Regular Rate per Unit $1.16 Gross Earnings Employee Tresor, A. 3. Paula Garvin, a food-supplements representative, had sales of $5695 with allowances of $462. If her commission rate is 8%, find her gross earnings. Solve for Paula’s gross earnings by showing all of your work. Page 1 of 3 4. Tim Mogilnitsky is a self-employed researcher.