ACT 420 Problem Set 3
.docx
keyboard_arrow_up
School
Arizona State University *
*We aren’t endorsed by this school
Course
440
Subject
Accounting
Date
Apr 24, 2024
Type
docx
Pages
3
Uploaded by mjeedzz on coursehero.com
ACT 420 Problem Set 3
Loss Adjustments
Instructions: submit your solutions to the following problems as an Excel file in Canvas. You should be able to copy data tables in these problems to Excel.
1.
Given the following data:
Claim Number
Loss Amount
1
10000
2
15000
3
30000
4
35000
Basic Limit = $25,000
Total limits severity trend = 10%
Calculate the excess loss trend. [Hint: how do capped and uncapped total losses change after application of the trend factor?]
2.
The current workers compensation indemnity benefit structure in a state is:
The compensation rate is 80% of the workers pre-injury wage.
The state average weekly wage (SAWW) is currently $1,500.
The minimum benefit is 50% of SAWW
The maximum benefit is 125% of SAWW
The following changes have been proposed to the benefit structure:
The proposed minimum benefit is 75% of SAWW
The proposed maximum benefit is 100% of SAWW
The distribution of wages for injured workers for Company A is:
Ratio to SAWW
# Workers
Total Weekly Wages
<50%
150
$ 108,750 50% - 75%
100
$ 110,000 75% - 100%
95
$ 137,750 100% - 125%
50
$ 87,500 >125%
45
$ 216,000 Total
440
$ 660,000 Calculate the impact to Company A of the proposed benefit change. (If you need to split a category, assume 50% of workers are in each subcategory.)
3.
An actuary is calculating a rate change to be effective 7/1/2020. Given the following:
Policies are written on a semi-annual basis.
Rates are expected to be in effect for one year.
The exposure base is non-inflationary.
The annual frequency and severity exponential trend fits based on data for the 12 months ending each quarter evaluated through 12/31/2018 are:
Number of
Points
Frequency
Exponential Fit
Severity
Exponential Fit
20 points
-2.9%
3.4%
16 points
-3.2%
3.0%
12 points
-2.5%
2.8%
8 points
-0.5%
2.9%
6 points
3.0%
3.1%
4 points
2.8%
3.3%
Calculate a pure premium trend factor that applies to accident year 2016, justifying the selected trends and methodology.
4.
Given the following information about two claims:
Claim Number
Accident Date
Transaction Date
Payment
Ending Reserve
1
1/1/2019
1/1/2019
$ - $ 20,000 1
1/1/2019
1/1/2020
$ 25,000 $ - 2
4/1/2019
7/1/2019
$ - $ 50,000 2
4/2/2019
10/1/2019
$ 25,000 $ 75,000 2
4/3/2019
4/1/2020
$ 100,000 $ 20,000 a)
Calculate the incurred losses for accident year 2019 as of 5/1/2020
b)
Calculate the incurred losses for calendar year 2019 and calendar year 2020
5.
Given the following information for an insurance company as of 12/31/2016:
Accident Year
Earned Premium
(,000)
Reported Loss
(,000)
Cumulative
Development
Factors
2012
$ 3,000 $ 1,500 1.05 2013
$ 3,500 $ 1,925 1.10 2014
$ 3,300 $ 1,749 1.20 2015
$ 3,200 $ 1,984 1.35 2016
$ 3,800 $ 2,470 1.40
All policies are annual
Annual loss cost trend = 3%
Calculate the trended, developed average losses that could be used to develop rates that would be in effect for one year beginning 1/1/2018.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
X
MindTap - Ceng: X M Mathway | Alget XU Microsoft 365 (F X
UD Microsoft 365 (F X Sign out
akeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
eBook
Salaries
Materials
Insurance
Utilities
Cost of inspection of materials for quality control
Promotion expenses
Advertising
Equipment depreciation
Cost of market survey
Problem 7-39 (LO. 5)
Blue Corporation, a manufacturing company, decided to develop a new line of merchandise. The project began in 2022. Blue had the
following expenditures in connection with the project, all incurred in the U.S.:
Amount of the deduction
Check My Work
49
2023
$500,000 $600,000
90,000 70,000
8,000
11,000
6,000
8,000
7,000
6,000
11,000
18,000
20,000
14,000
144
2022
$
f
The new product will be introduced for sale beginning in April 2024.
If an amount is zero, enter "0". Calculate the monthly expense to the nearest dollar and use in subsequent computations.
a. Determine Blue Corporation's research and experimental…
arrow_forward
A customer service department has the following resolution response time data:
Average Response Time
First contact
Service scheduling
Wait for service
Service
0.25 hr.
0.50 hr.
24.00 hrs.
1.50 hrs.
26.25 hrs.
Total resolution time
What is the value-added ratio (rounded to one decimal place) in this process?
Oa. 8.6%
Ob. 91.4%
Oc. 28.6%
Od. 5.7%
arrow_forward
pject: Company Accour X
DEL. Project Guidelines and Rubric x
DEL 7-1 Problem Set: Module Sev X
CengageNOWv2 |Online tea x
com/ilm/takeAssignment/takeAssignmentMain.do?invoker3D&takeAssignmentSessionLocator3D&inprogress=false
eBook
4Show Me How
Return on Total Assets
A company reports the following income statement and balance sheet information for the current year:
Net income
$224,540
Interest expense
39,620
000'080
Determine the return on total assets. If required, round the answer to one decimal place.
Average total assets
Feedback
Check My Work
Divide the sum of net income and interest expense by average total assets.
Check My Work
( Previous
*AD
dy
arrow_forward
File
Tools
View
UTS MK I GSL 20-21 (19.10.20 -13.30) - Word (Product Activation Failed)
W
UTS MK I GSL 20-21 (19.10.20 -13.30) * x
Document2
Problem 1
Balance Shet
Income Statement
PT. MaTaHtari
PT. MATAH+ari
For the year Ended December 31
For the year Ended December 31
2019
2018
ASSET
Sales Revenue
10.000.000.000
Cash
550.000.000
700.000.000
Cost of Good Sold
6.400.000.000
Marketable Securities
500.000.000
300.000.000
Gross Profit
Account Receivable
700.000.000
550.000.000
Inventory
750.000.000
650.000.00D
3.600000.000
Total Currevt Assit
2.500.000.000
2.200.000.000
Operating Expenses
Selling Expenses
200.000.000
Gross Fixed Asset
3.000.000.000
General & Administrative Expenses
150.000.000
4.000.000.000
Less : Accumulated Depreciation
Depreciation Expenses
250.000.000
500.000.000
200.000.000
Nett Fred Assit
Total Operating Expenses
3.500.000.000
2.800.000.000
600.000.000 Operating Profit
TOTAL ASSET
6.000.000.000
5.000.000.000
3.000.000.000 Interest Expenses
JABILITIBS E STOCKHOLDER'S…
arrow_forward
Calculate the Perfect Delivery Index for the carrier. You may use
Carriers
Carrier 1
92.2
95.3
92.7
O 95.0
On Time %
98%
Damage-Free % Billing Accuracy % Avg Transit Time Shortage Rate
5%
95%
99%
3
arrow_forward
Discuss the relationship between CAPM Model and Fama and French (1993) three factors model with the index models.
Give correct step by step typed answer with proper explanation of it. Will give upvote only for the correct answer. Answer within 40 min maximum . Thank you .
arrow_forward
I need calculator and excel steps on how to do this one....book answer = 6.07%
arrow_forward
a) PWA = $_______ ; PWB = $_______-; PWC = $_________
b) IRRA =______% ; IRRB = _______% ; IRRC = _________%
Manual complete solution needed. thank you. will give like for sure
arrow_forward
Pls provide the solution with 10 min i will give like for sure
Try to give solution in typed form.
arrow_forward
engageNOWV2 | Assignme CengageNOWv2 |Unlın X
now.com/ilrm/takeAssignment/takeAssignmentMain.do?invoker%3D8takeAssignmentSessionLocator3&inprogress%3false
Calculator
Equipment with a cost of $220,000 has an estimated residual value of $30,000 and an estimated life of 10 years or 19,000 hours. It is to be depreciated
by the straight-line method. What is the anount of depreciation for the first full year, during which the equipment was used for 2,100 hours?
Oa. $21,000
Ob. $22,000
Oc. $19,000
Od. $30,000
Previous
Next
8:21 AM
5/4/2020
arrow_forward
Danielle Battle has trouble keeping her debits and credits equal. During a recent month, Danielle made the following errors:
In preparing the trial balance, Danielle omitted a $5,800 note payable.
Danielle recorded a $230 purchase of supplies on account by debiting Supplies and crediting Accounts Payable for $320.
In recording a $280 payment on account, Danielle debited Supplies instead of Accounts Payable.
In journalizing a receipt of cash from service revenue, Danielle debited Cash for $80 instead of the correct amount of $800. The credit was correct.
Danielle posted a $900 utility expense as $90. The credit to Cash was correct.
а.
b.
c.
d.
е.
Required
For each of these errors, state whether total debits equal total credits on the trial balance.
1.
2.
Identify each account that has an incorrect balance, and indicate the amount and direction of the error (such as "Accounts Receivable $500 too high").
Requirement 1. For each of these errors, state whether total debits equal total…
arrow_forward
In the screenshot below the array C4# is hidden
Convert the 6 rents to a dynamic array Find cumulative frequency
=COUNTIF(B4#,"<="&B4#)
1
=A4:A9
3 Rent
Rent
С.F.
4
$500
$500
$500
$500
6.
$600
$600
$500
$500
8.
$400
$400
9.
$600
$600
10
what are the values in C4#
O a
4.
4.
6.
4.
1
Ob.
2.
4
1
O d. None of the other options is correct
arrow_forward
True/False/Uncertain plz solve it within 30-40 mins I'll give you multiple upvote
arrow_forward
O Quiz Tools
Enabled: Chapter 3 Linear Programming: Formu... 0
Save &E
Saved
Help
100%
In a transportation problem with 4 sources and 2 destinations, how many shipping lanes will exist?
Shipping lanes
Collapse
Hill
R
Y
D
F
G
H
K
B
N
arrow_forward
minutes, 40 seconds.
v Question Completion Status:
A Moving to another question will save this response.
Quèstion 7
According to the FASB hierarchy of fundamental qualitative characteristics, the two primary qualities making accounting information useful are
O understandability and decision usefulness
relevance and faithful representation
verifiability and neutrality
O predictive value and feedback value
A Moving to another question will save this response.
..
e Type here to search
acer
F7
F8
F9
F6
arrow_forward
Required information.
Excel Analytics 12-01 (Static) Quality Cost Report [LO12-2]
To complete this activity, you will need to have Excel installed on your computer. This exercise requires you to work in
Excel and answer questions in Connect. You will read a brief scenario and then download an Excel file that you will need
to complete the requirements in Parts 1 through 3 of this exercise.
Some of the requirements include brief video tutorials on using Excel functions. After viewing the tutorials, you will then
use what you learned to work directly in Excel to answer the required questions in Connect.
[The following information applies to the questions displayed below.]
Harvey Company designs and produces surgical lasers. Its product is brilliantly designed, but the manufacturing process
has been plagued by chronic quality control problems. To help address the situation, Harvey formed a cross-functional
team of managers that quantified its costs of quality over the last two quarters as…
arrow_forward
a. Calculate the expected value of return, i, for the asset.
Data Table
(Click on the icon located on the top-right corner of the data table below in order to
copy its contents into a spreadsheet.)
Return, r
40.00%
Pr
1
0.10
10.00%
0.00%
2
0.20
3
0.40
0.20
- 5.00%
0.10
- 10.00%
Print
Done
arrow_forward
Savee
Assume the following information:
Hours
Queue time
Wait time
40
24
2.
2.
Process time
Move time
Inspection time
4.
The monufocturing cycle efficiency (MCE) is closest to:
Multiple Cholce
0.24
0.40.
0.02
0.04.
arrow_forward
PDE Management skills 10-9-2020.pc X
E PrinciplesofManagement- open X
File | C:/Users/HPPAVI~1/AppData/Local/Temp/Rar$Dla14276.26713/PrinciplesofManagement%20-%20openStax...
O Erase
F Highlight
|A Read aloud Draw
U Chapter Review Questions
1. What are the characteristics and traits that you possess that are common to all successful|managers?
2. Why should management be considered an occupation rather than a profession?
3. How do managers learn how to perform the job?
4. Explain the manager's job according to Henry Mintzberg.
5. What responsibilities do managers have towards people within the organization? How do they express
these responsibilities?
6. How do managers perform their job according to John Kotter?
7. How do managers make rational decisions?
This OpenStax book is available for free at http://cnx.org/content/col28330/1.8
Chapter 1 Managing and Performing
19
8. How does the nature of management change according to one's level and function in the organization?
9. Discuss the…
arrow_forward
Online Test Window-Google Chrome
tests.mettl.com/test-window/f55ac827#/testWindow/0/10/1
EY
Accounting Assessment O
Total 00:55:19
Finish Test
Section 1 of 1
Section #1 v
1.
2 3
4.
51
8 9
10
11
11 of 45
All
2
43
Question # 11
Revisit
Choose the best option
Net profit is calculated as:
Sales minus cost of sales.
O Sales plus overheads.
O Gross profit minus overheadş.
O Gross profit minus cost of sales.
Prec Queston
Next Question
+91-82878-03040
+1-650-924-9221
Zaineh Support
413 PM
meti
1/16/2021
arrow_forward
DA. 7-2 Project: Company Accour x
D2L 7-1 Problem Set: Module Sev X
CengageNOWv2 |Online tea X
Cengage Learning
+ x
ngagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker3D&takeAssignmentSessionLocator=&inprogress%3Dfalse
电 手
eBook
Show Me How
Long-Term Solvency Analysis
The following information was taken from Celebrate Company's balance sheet:
Fixed assets (net)
006'86$
000
1,471,050
Long-term liabilities
Total liabilities
Total stockholders' equity
1,634,500
Determine the company's (a) ratio of fixed assets to long-term liabilities and (b) ratio of liabilities to stockholders' equity. If required, round your answers
to one decimal place.
a. Ratio of fixed assets to long-term liabilities
b. Ratio of liabilities to stockholders equity
(Previous
Check My Work
330 PM
hp
144
114
arrow_forward
C Total Fixed Ov
[Solved] Brads x
( 8.3 Calculation x
W (SOLVED) Brad x
b Total Fixed Ove X
b Total Fixed Ove X
C Fixed Overhea X
b Fixed Overhea x
+
->
A bartleby.com/solution-answer/chapter-10-problem-31bea-managerial-accounting-the-cornerstone-of-business-decision-making-7th-edition/9781337115773/fixed-overhea. Q
= bartleby
Q Search for textbooks, step-by-step explanations to homework questions,
E Ask an Expert
+ Managerial Accounting: The Cornerstone...
O Get 24/7 homework help and experts with bartleby learn. Subscribe now! >
Publisher: Cengage Learning
typically answered in as fast as 30
minutes.*
ISBN: 9781337115773
Fixed Overhead Spending and Volume Variances, Columnar and
Formula Approaches
Solutions
See Solution
Branch Company provided the following information:
Chapter
*Response times vary by subject and
Standard fixed overhead rate (SFOR) per direct labor hour
$5.00
question complexity. Median response time
10 Standard Costing And Variance -
is 34 minutes and may be longer…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
Related Questions
- X MindTap - Ceng: X M Mathway | Alget XU Microsoft 365 (F X UD Microsoft 365 (F X Sign out akeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false eBook Salaries Materials Insurance Utilities Cost of inspection of materials for quality control Promotion expenses Advertising Equipment depreciation Cost of market survey Problem 7-39 (LO. 5) Blue Corporation, a manufacturing company, decided to develop a new line of merchandise. The project began in 2022. Blue had the following expenditures in connection with the project, all incurred in the U.S.: Amount of the deduction Check My Work 49 2023 $500,000 $600,000 90,000 70,000 8,000 11,000 6,000 8,000 7,000 6,000 11,000 18,000 20,000 14,000 144 2022 $ f The new product will be introduced for sale beginning in April 2024. If an amount is zero, enter "0". Calculate the monthly expense to the nearest dollar and use in subsequent computations. a. Determine Blue Corporation's research and experimental…arrow_forwardA customer service department has the following resolution response time data: Average Response Time First contact Service scheduling Wait for service Service 0.25 hr. 0.50 hr. 24.00 hrs. 1.50 hrs. 26.25 hrs. Total resolution time What is the value-added ratio (rounded to one decimal place) in this process? Oa. 8.6% Ob. 91.4% Oc. 28.6% Od. 5.7%arrow_forwardpject: Company Accour X DEL. Project Guidelines and Rubric x DEL 7-1 Problem Set: Module Sev X CengageNOWv2 |Online tea x com/ilm/takeAssignment/takeAssignmentMain.do?invoker3D&takeAssignmentSessionLocator3D&inprogress=false eBook 4Show Me How Return on Total Assets A company reports the following income statement and balance sheet information for the current year: Net income $224,540 Interest expense 39,620 000'080 Determine the return on total assets. If required, round the answer to one decimal place. Average total assets Feedback Check My Work Divide the sum of net income and interest expense by average total assets. Check My Work ( Previous *AD dyarrow_forward
- File Tools View UTS MK I GSL 20-21 (19.10.20 -13.30) - Word (Product Activation Failed) W UTS MK I GSL 20-21 (19.10.20 -13.30) * x Document2 Problem 1 Balance Shet Income Statement PT. MaTaHtari PT. MATAH+ari For the year Ended December 31 For the year Ended December 31 2019 2018 ASSET Sales Revenue 10.000.000.000 Cash 550.000.000 700.000.000 Cost of Good Sold 6.400.000.000 Marketable Securities 500.000.000 300.000.000 Gross Profit Account Receivable 700.000.000 550.000.000 Inventory 750.000.000 650.000.00D 3.600000.000 Total Currevt Assit 2.500.000.000 2.200.000.000 Operating Expenses Selling Expenses 200.000.000 Gross Fixed Asset 3.000.000.000 General & Administrative Expenses 150.000.000 4.000.000.000 Less : Accumulated Depreciation Depreciation Expenses 250.000.000 500.000.000 200.000.000 Nett Fred Assit Total Operating Expenses 3.500.000.000 2.800.000.000 600.000.000 Operating Profit TOTAL ASSET 6.000.000.000 5.000.000.000 3.000.000.000 Interest Expenses JABILITIBS E STOCKHOLDER'S…arrow_forwardCalculate the Perfect Delivery Index for the carrier. You may use Carriers Carrier 1 92.2 95.3 92.7 O 95.0 On Time % 98% Damage-Free % Billing Accuracy % Avg Transit Time Shortage Rate 5% 95% 99% 3arrow_forwardDiscuss the relationship between CAPM Model and Fama and French (1993) three factors model with the index models. Give correct step by step typed answer with proper explanation of it. Will give upvote only for the correct answer. Answer within 40 min maximum . Thank you .arrow_forward
- I need calculator and excel steps on how to do this one....book answer = 6.07%arrow_forwarda) PWA = $_______ ; PWB = $_______-; PWC = $_________ b) IRRA =______% ; IRRB = _______% ; IRRC = _________% Manual complete solution needed. thank you. will give like for surearrow_forwardPls provide the solution with 10 min i will give like for sure Try to give solution in typed form.arrow_forward
- engageNOWV2 | Assignme CengageNOWv2 |Unlın X now.com/ilrm/takeAssignment/takeAssignmentMain.do?invoker%3D8takeAssignmentSessionLocator3&inprogress%3false Calculator Equipment with a cost of $220,000 has an estimated residual value of $30,000 and an estimated life of 10 years or 19,000 hours. It is to be depreciated by the straight-line method. What is the anount of depreciation for the first full year, during which the equipment was used for 2,100 hours? Oa. $21,000 Ob. $22,000 Oc. $19,000 Od. $30,000 Previous Next 8:21 AM 5/4/2020arrow_forwardDanielle Battle has trouble keeping her debits and credits equal. During a recent month, Danielle made the following errors: In preparing the trial balance, Danielle omitted a $5,800 note payable. Danielle recorded a $230 purchase of supplies on account by debiting Supplies and crediting Accounts Payable for $320. In recording a $280 payment on account, Danielle debited Supplies instead of Accounts Payable. In journalizing a receipt of cash from service revenue, Danielle debited Cash for $80 instead of the correct amount of $800. The credit was correct. Danielle posted a $900 utility expense as $90. The credit to Cash was correct. а. b. c. d. е. Required For each of these errors, state whether total debits equal total credits on the trial balance. 1. 2. Identify each account that has an incorrect balance, and indicate the amount and direction of the error (such as "Accounts Receivable $500 too high"). Requirement 1. For each of these errors, state whether total debits equal total…arrow_forwardIn the screenshot below the array C4# is hidden Convert the 6 rents to a dynamic array Find cumulative frequency =COUNTIF(B4#,"<="&B4#) 1 =A4:A9 3 Rent Rent С.F. 4 $500 $500 $500 $500 6. $600 $600 $500 $500 8. $400 $400 9. $600 $600 10 what are the values in C4# O a 4. 4. 6. 4. 1 Ob. 2. 4 1 O d. None of the other options is correctarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE LEssentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,