{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-28T07:49:48-04:00", "answer_date": "2024-06-28 07:49:48", "is_docs_available": null, "is_excel_available": null, "is_pdf_available": null, "count_file_available": 0, "main_page": "student_question_view", "question_id": "4266850", "url": "\/study-help\/questions\/question-i-need-help-with-the-steps-of-this-problem-4266850", "question_creation_date_js": "2024-06-28T07:49:48-04:00", "question_creation_date": "Jun 28, 2024 07:49 AM", "meta_title": "[Solved] Question: I need help with the steps of t | SolutionInn", "meta_description": "Answer of - Question: I need help with the steps of this problem - even Chegg was not detailed enough. I need step-by-step instruc | SolutionInn", "meta_keywords": "question,help,steps,problem,-,chegg,detailed,step--step,instruction,cell,psiuniform,formula", "question_title_h1": "Question: I need help with the steps of this problem - even Chegg was not detailed enough. I need step-by-step instruction. for example, I do", "question_title": "Question: I need help with the steps of this problem - even", "question_title_for_js_snippet": "Question I need help with the steps of this problem even Chegg was not detailed enough I need step by step instruction for example, I do not know what cell I use the PsiUniform formula in If you have Frontline Solver and can provide help by 9am this morning (november 2), please respond fromSpreadsheet Modeling and Decision Analysis(7th Edition), chapter 12, problem 3 Feel free to ask questions, if any Thank you Hungry Hungry Dawg Dawg Restaurants Restaurants Initial Conditions Number of Covered Employees 18,533 Average Claim per Employee $250 Amount Contributed per Employe $125 Number of Employee Avg Claim Month EmployeesContributions per Emp 1 19,605 $2,450,607 $251 58 2 19,113 $2,389,120 $254 17 3 19,026 $2,378,243 $257 78 4 18,966 $2,370,770 $262 01 5 18,655 $2,331,845 $261 27 6 19,733 $2,466,582 $261 87 7 19,759 $2,469,840 $268 47 8 20,732 $2,591,545 $272 92 9 20,621 $2,577,617 $274 68 10 21,042 $2,630,224 $278 98 11 21,367 $2,670,816 $280 16 12 22,258 $2,782,252 $280 10 Assumptions Max Decrease 3 0 Max Increase 7 Mthly Increase1 0 Std Dev $3 Constant Total Company Claims Cost $4,932,101 $2,481,494 $4,857,921 $2,468,801 $4,904,475 $2,526,232 $4,969,326 $2,598,557 $4,873,918 $2,542,074 $5,167,417 $2,700,835 $5,304,650 $2,834,810 $5,658,246 $3,066,701 $5,664,063 $3,086,446 $5,870,224 $3,239,999 $5,986,026 $3,315,209 $6,234,462 $3,452,209 Total Company Cost $34,313,367 insufficient funds P(insufficient funds) month seasonal factor 1 2 3 4 5 6 7 0 8 0 85 0 87 0 92 0 93 1 15 1 2 Uniform Normal 8 9 10 11 12 1 18 1 03 0 95 0 98 1 14 Confidence Intervals Confidence Intervals Sample Mean Sample Standard Deviation Sample Size Significance Level NAME NAME 5000 5 95 LCL for the population mean 95 UCL for the population mean NAME NAME Target Proportion 95 Lower Confidence Limit 95 Upper Confidence Limit 0 900 0 892 0 908 Page 3", "question_description": "

Question:<\/strong><\/p>

I need help with the steps of this problem - even Chegg was not detailed enough.<\/p>

I need step-by-step instruction. for example, I do not know what cell I use the PsiUniform formula in.<\/p>

If you have Frontline Solver and can provide help by 9am this morning (november 2), please respond<\/strong><\/p>

fromSpreadsheet Modeling and Decision Analysis(7th Edition), chapter 12, problem 3<\/p>

Feel free to ask questions, if any. Thank you<\/p>

<\/p>\"image Hungry Hungry Dawg Dawg Restaurants Restaurants Initial Conditions: Number of Covered Employees 18,533 Average Claim per Employee $250 Amount Contributed per Employe $125 Number of Employee Avg Claim Month EmployeesContributions per Emp. 1 19,605 $2,450,607 $251.58 2 19,113 $2,389,120 $254.17 3 19,026 $2,378,243 $257.78 4 18,966 $2,370,770 $262.01 5 18,655 $2,331,845 $261.27 6 19,733 $2,466,582 $261.87 7 19,759 $2,469,840 $268.47 8 20,732 $2,591,545 $272.92 9 20,621 $2,577,617 $274.68 10 21,042 $2,630,224 $278.98 11 21,367 $2,670,816 $280.16 12 22,258 $2,782,252 $280.10 Assumptions: Max Decrease 3.0% Max Increase 7% Mthly Increase1.0% Std Dev $3 Constant Total Company Claims Cost $4,932,101 $2,481,494 $4,857,921 $2,468,801 $4,904,475 $2,526,232 $4,969,326 $2,598,557 $4,873,918 $2,542,074 $5,167,417 $2,700,835 $5,304,650 $2,834,810 $5,658,246 $3,066,701 $5,664,063 $3,086,446 $5,870,224 $3,239,999 $5,986,026 $3,315,209 $6,234,462 $3,452,209 Total Company Cost $34,313,367 insufficient funds? P(insufficient funds) month seasonal factor 1 2 3 4 5 6 7 0.8 0.85 0.87 0.92 0.93 1.15 1.2 Uniform Normal 8 9 10 11 12 1.18 1.03 0.95 0.98 1.14 Confidence Intervals Confidence Intervals Sample Mean Sample Standard Deviation Sample Size Significance Level #NAME? #NAME? 5000 5% 95% LCL for the population mean 95% UCL for the population mean #NAME? #NAME? Target Proportion 95% Lower Confidence Limit 95% Upper Confidence Limit 0.900 0.892 0.908 Page 3", "transcribed_text": "", "related_book": { "title": "Income Tax Fundamentals 2013", "isbn": "1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516", "edition": "31st Edition", "authors": "Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/1124.jpg", "uri": "\/textbooks\/income-tax-fundamentals-2013-31st-edition-9781285586618", "see_more_uri": "" }, "free_related_book": { "isbn": "0393634973", "uri": "\/textbooks\/the-apocalypse-factory-plutonium-and-the-making-of-the-atomic-age-1st-edition-978-0393634976-290463", "name": "The Apocalypse Factory Plutonium And The Making Of The Atomic Age", "edition": "1st Edition" }, "question_posted": "2024-06-28 07:49:48", "see_more_questions_link": "\/study-help\/questions\/business-economics-2023-September-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/the-stockholders-equity-section-of-peter-corporations-balance-sheet-at", "description": "The stockholders equity section of Peter Corporations balance sheet at December 31, 2014, follows: Common stock ($10 par value); authorized 1,000,000 shares, issued and outstanding 900,000 shares $...", "stars": 3 }, { "url": "\/study-help\/psychology\/how-has-the-researcher-addressed-the-tension-between-potentially-conflicting-1979953", "description": "How has the researcher addressed the tension between potentially conflicting demands of paradigms in the design and implementation of the study?", "stars": 3 }, { "url": "\/two-different-analytical-tests-can-be-used-to-determine-the", "description": "Two different analytical tests can be used to determine the impurity level in steel alloys. Eight specimens are tested using both procedures, and the results are shown in the following tabulation. Is...", "stars": 3 }, { "url": "\/study-help\/questions\/you-open-a-margin-account-at-chas-pigeon-a-discount-9874276", "description": "You open a margin account at Chas Pigeon, a discount broker. You subsequently short Exciting.com at $286, believing it to be overpriced. This transaction is done on margin, which has an annual...", "stars": 3 }, { "url": "\/study-help\/questions\/repeat-problem-4-for-mary-psk-4-a-generator-matrix-1433444", "description": "Repeat Problem 4 For M-Ary PSK. 4. A Generator Matrix G= [1 0 1 1 1 1 0 Generates A (4,2) Code. (A) Is This A Systematic Code? (B) What Is The Parity Check Matrix Of This Code? (C) Find The Codewords...", "stars": 3 }, { "url": "\/study-help\/questions\/a-brodie-is-uncertain-if-the-cost-presented-in-exhibit-1004536", "description": "a. Brodie is uncertain if the cost presented in Exhibit 2 are appropriate for determining the EOQs. What changes would you recommend, and why? Should the cost of the three idle part-time workers be...", "stars": 3 }, { "url": "\/study-help\/questions\/based-on-the-method-of-least-squares-what-are-the-1024395", "description": "Based on the method of least squares, what are the estimated weights of balls A and B? Round your answer to the nearest tenth in the format of x.x). = 2.6 B= 3.6 Answer 1: Correct! 2.6 Answer 2:...", "stars": 3 }, { "url": "\/study-help\/questions\/broad-stakeholder-objectives-form-the-backdrop-to-operations-decisionmaking-and-1003702", "description": "Broad stakeholder objectives form the backdrop to operations decision-making, and top management's objectives provide a strategic framework. Outline five operations performance objectives. [25 Marks]...", "stars": 3 }, { "url": "\/study-help\/questions\/total-quality-management-the-us-department-of-commerce-through-1008640", "description": "Total Quality Management - The U.S. Department of Commerce through the National Institute of Standards and Technology have several questionnaires that can help businesses evaluate their Performance....", "stars": 3 }, { "url": "\/study-help\/questions\/a-radial-fan-is-used-to-circulate-fresh-air-p-1024193", "description": "A radial fan is used to circulate fresh air (p = 1.20 kg\/m) through a building. The fan operates at = 4000 rpm, has a volume flow rate of 0.8 m\/s, and requires 2 kW to run. The blade geometry is...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/advantage-first-corperation-has-sales-of-4244949-incom-tax-of-4266849", "next": "\/study-help\/questions\/warner-co-has-budgeting-fixed-overhead-of-150000-practical-capacity-4266851" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "Question: I need help with the steps of this problem - even", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/question-i-need-help-with-the-steps-of-this-problem-4266850" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } } } }