Need help with Case D. Thank You Case A - You have decided to start planning for your retirement. You already have $11,000in your investment account. You plan to put an additional $4,000 into the account at theBEGINNING of each year for the next 10 years and then put $6,000 into the account at theBEGINNING of each of the following 30 years. Your account is expected to grow at 6.5%interest (tax free) annually.Prepare a schedule to show (1.) the year (1 through 40), (2.) the beginning balance eachyear, (3.) the amount of interest earned each year, (4.) the deposit each year, and (5.) theending balance each year.Format each of the dollar amounts with two decimals.Please include totals at the bottom of your spreadsheet for (1) the amount of interest and (2)the amount of deposits during the entire 40 year (10 + 30) year time.Case B - You estimate that you will have $43,000 of school loans by the time you graduate.Your school loan is to be paid off over 10 years but you plan to pay it off over a 4 yearperiod with payments being made at the END of each MONTH for the 4 years followinggraduation. Assume your school loans charge 6% interest compounded MONTHLY.Prepare a schedule to show (1) the month number (i.e. #1 - #48), (2) the beginning loanbalance each month, (3) the payment each month, (4) the amount of interest in each monthlypayment, (5) the amount of principal in each monthly payment, and (6) the ending balanceeach month.Format each of the amounts with two decimals.Please include totals at the bottom of your spreadsheet for (1) the amount of payments, (2) theamount of interest, and (3) the amount of principal which was paid during the 48 month term ofthe loan. Case C - After attending a recent meeting of The Accounting Society, you were inspired to seta goal to be able to retire with $2,000,000. You will put $6,000 of your savings into aretirement fund on January 1, 2022. After you graduate, you plan to make additional annualdeposits into a fund at the BEGINNING of each of the 30 years, starting on January 1, 2025.These deposits will not be $6,000 but they will be in equal amounts each year (annuity due sincepayments are at the BEGINNING of each year). The fund will earn 7% interest compoundedannually for all 33 years.Prepare a schedule to show (1) the year (i.e. 2022, 2023, etc.), (2) the beginning balanceeach year, (3) the amount of the deposit each year, (4) the amount of interest each year, and(5) the ending balance each year. Format each of the amounts with two decimals.Please include totals at the bottom of your spreadsheet for the amount of deposits and theamount of interest earned during the entire 33 year period (3 years without deposits and 30years with deposits).Case D - Your company has been selling the following furniture products:FurnitureProductSofasSalesin 2019$86,070121,492153,09842,44963,20856,29431.648you figureSalesin 2020$93,402129,62796,30433,60885,96667,20155,023you figureLovescatsChairsOttomansBedsDressersTablesТОTALSPrepare a table of ALL of the above information, including totals at the bottom of each columnwhich is measured in dollars:Sorted alphabetically by product (then print the information)Sorted from highest to lowest based on sales in 2020 (then print the information).1.2.Prepare the following charts:With the list sorted alphabetically and the amounts in dollars (from part 1), prepare aclustered column chart of the 2019 salces and 2020 sales shown side by side for eachproduct. Please format this chart so that the dollar amount appears at the top of eachcolumn in the chart.With the list sorted from highest to lowest based on sales in 2020 (from part 2), preparea pie chart of the 2020 sales with the amounts for cach product shown in percentages ofthe total for the year, rather than dollars.3.4.

1. Alphabetically sorted info: 2. Information sorted based on highest to lowest sales value in 20203. 4.

Case D - Your company has been selling the following furniture products: Furniture Sales Product Sofas Loveseats Chairs Ottomans Beds in 2019 $86,070 121,492 153,098 42,449 63,208 56,294 31,648 you figure Sales in 2020 $93,402 129,627 96,304 33,608 85,966 67,201 55,023 you figure Dressers Tables ΤΟTALS Prepare a table of ALL of the above information, including totals at the bottom of each column which is measured in dollars: 1. Sorted alphabetically by product (then print the information) 2. Sorted from highest to lowest based on sules in 2020 (then print the information). Prepare the following charts: 3. With the list sorted alphabetically and the amounts in dollars (from part 1), prepare a clustered column chart of the 2019 sales and 2020 sales shown side by side for each product. Please format this chart so that the dollar amount appears at the top of each column in the chart, With the list sorted from highest to lowest based on sales in 2020 (from purt 2), prepare a pie chart of the 2020 sales with the amounts for cach product shown in percentages of the total for the year, rather than dollars. 4.

Case D - Your company has been selling the following furniture products: Furniture Sales Product Sofas Loveseats Chairs Ottomans Beds in 2019 $86,070 121,492 153,098 42,449 63,208 56,294 31,648 you figure Sales in 2020 $93,402 129,627 96,304 33,608 85,966 67,201 55,023 you figure Dressers Tables ΤΟTALS Prepare a table of ALL of the above information, including totals at the bottom of each column which is measured in dollars: 1. Sorted alphabetically by product (then print the information) 2. Sorted from highest to lowest based on sules in 2020 (then print the information). Prepare the following charts: 3. With the list sorted alphabetically and the amounts in dollars (from part 1), prepare a clustered column chart of the 2019 sales and 2020 sales shown side by side for each product. Please format this chart so that the dollar amount appears at the top of each column in the chart, With the list sorted from highest to lowest based on sales in 2020 (from purt 2), prepare a pie chart of the 2020 sales with the amounts for cach product shown in percentages of the total for the year, rather than dollars. 4.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

University of Phoenix Material The Role of a Health Care Manager Health care management is a growing profession. These managers are expected to manage inpatient and outpatient care facilities as well as non-direct care settings. Therefore, it is important for health care managers to understand the complexity of its roles and functions to build the necessary skills to help them be successful. Complete the following table in which you identify and discuss the role of the health care manager in the following functions: organizing, planning, controlling and leading. In the spaces provided, ensure you identify and discuss them according to these guidelines: Define each of the functions listed. You must define the function in your own words; do not copy the definition from a textbook. Identify and discuss the role of a health care manager in the given function. Provide an explanation that illustrates the role of a health care manager as it applies to the function in the health care…
Case Background: You are a marketing manager for Sunflower Moving Company, a company that helps people move their belongings from one residence to another. As part of the company's efforts to remain competitive, a study is implemented to examine factors that drive the sales of its moving services and products. Instructions: In addition to offering moving services, Sunflower Moving Company also sells moving supplies such as boxes, packing supplies, tie-down ropes, covers and bags, short-term storage options, bike racks, wheelchair carriers, motorcycle towing, etc. An initial study was conducted to examine the relationship between the sales levels of Sunflower's moving supplies and the price of its products. A regression model yielded an R-Square value of 45%. Interpret this statistic. Do you think this statistic indicates that Price is a good predictor of Sales? Justify your answer. You direct your market research team to expand the study. Besides Price, suggest 3 other predictor…
5
Explain work breakdown structure (WBS)?
Case management is a core approach with most settings that manage clients; Define what it means and then outline the process used within it; engagement assessment, intervention and evaluation. Define each one and give an example of what each would look like with a client.
9:28 < Вack Assignment Case - 1 Management in Action Tim and Richard Smucker Manage a Great Place to Work According to a study conducted for Fortune magazine by the Great Place to Work Institute, the best company to work for in America is headquartered in Orrville, Ohio (population 8,000). Orrville is a quiet, tidy town 50 miles south of Cleveland. Employees don't get any razzle-dazzle perk such as pet insurance. The J.M. Smucker Co. is a 107-year-old, family- controlled business that is run by two brothers who tend to quote the New Testament and Ben Franklin. It's a throwback to a simpler time. Smucker's gimmick-free management starts with the co-CÉO,, Tim and Richard Smucker, who took the reins in 2001. Tim and Richard are popular with the 2,930 employees-they're affectionately known as the "boys"-which isn't too surprising given that the company's stock had a total return of 100 percent during the past five years. (The vast majority of stocks lost about 25 percent in value during…
Course: Principle of Healthcare Finances First Question: What are some areas of supervision that a financial manager might be responsible for within a healthcare organization? Answer: Some areas of supervision for financial managers in healthcare organizations are as follows: Financial reporting and budgeting. Procurement of financing, their sources, and ensuring that the organization is legally authorized to procure such finance. Finding new opportunities and analyzing their prospects. Efficient use of available resources. Technological upgrades of medical equipment. Facilitating funds for medical research & development. Second Question: Why is it important for managers to recruit individuals who can work as a team? Answer: Recruiting individuals who can work as a team is important for managers because it ensures that they work better in an organization, hence become more productive. In addition, individuals who can work in a group try to manage the work efficiently and together…
match to the correct job 1: LEGAL NURSE CONSULTANT 2: FORENSIC PSYCHOLOGIST 3: FORENSIC ANTHROPOLOGIST 4: FORENSIC DOCUMENT EXAMINER 5: DEATH INVESTIGATOR 6: CRIMINALISTICS SPECIALIST 7: CORONER 8: CLINICAL FORENSIC NURSE 9: FORENSIC ENGINEER 10: FORENSIC SOCIAL WORKER 11: FIREARM & TOOL MARK EXAMINER 12: FORENSIC PATHOLOGIST 13: FORENSIC ACCOUNTANT 14: FORENSIC ODONTOLOGIST 15: CORRECTIONAL HEALTH NURSE 16: FORENSIC PSYCHIATRIST 17: FORENSIC ENTOMOLOGIST 18: SEXUAL ASSAULT NURSE EXAMINER 19: TOXICOLOGIST 20: FORENSIC BOTANIST job description: 1: Determines the cause of death by examination of a cadaver via autopsy, usually during the investigation of criminal law cases and civil law cases in some jurisdictions. 2: Uses insects, and their arthropod relatives that inhabit decomposing remains to aid legal investigations 3. Handles, examines and evaluates dental evidence in the interest of justice, usually for identification. 4. Performs forensic…
How can you define the number of client relationships in terms of the balanced scorecard?
Human Resource Development Question 1: Explain an example to illustrate how training is an open system with indirect organizational outputs. Question 2: Mager & Pipe's flowchart distinguishes between two general types of sources of training discrepancies. Describe what is a training discrepancy.
What are safety precautions for coronavirus in offices?
THE CYCLE OF INDIVIDUAL PERFORMANCE 1: Why is it Important to View Performance Over a Period of Time vs. at a Single Point in Time provides a thorough and detailed identification of why it is important to view performance over a period of time versus at a single point in time. Several sources and examples support thinking. 2: Preferred Review Cycle Time Establish and provide a thorough and detailed review of a preferred cycle time based on alternative choices, including a rationale for their choice. Several sources and examples support thinking. 3: Factors that Can Influence Individual Performance Give a thorough and detailed description of at least 6 different factors that can influence individual performance and impact an individual’s performance review at the end of the cycle. Several sources and examples support thinking. 4: Strategies for Preventing Individual Performance from Becoming De-Railed provides a thorough and detailed discussion about strategies essential to…