Jay Corporation has decided to prepare contribution income statements for internal planning. Budgeted information for Quarter 1 of 2024: Sales in units Sales price per unit after analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) $29.00 Sales Commissions (per dollar of sales) 9.50% Administrative Salaries (per quarter) Rent Expense (per quarter) Depreciation Expense (per quarter) Shipping has been determined to be a mixed cost with the following total costs and units: 2022 17,000 $48.00 Quarter 1 Quarter 2 Quarter 3 Quarter 4 $45,000 $27,000 $36,000 Total Cost $67,000 $94,000 $89,800 $92,600 Units 12,500 21,000 13,800 20,000
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
![1R x 8C
3
4
5
6
=
7
-
8
=
9
10
11
12
13
7
14
2
File
16
Dv
23
1
2
Jay Corporation has decided to prepare contribution income statements for internal planning.
77
17 2022
18
19
20
21
22
Home
v
A
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Review View Help
✓11 v B
EA ... Ev ab
X✓ fx Accessibility tab summary: Information about Jay Corporation is presented in row 2. Financial information of the com
F
K
N
Budgeted information for Quarter 1 of 2024:
Sales in units
Sales price per unit
2023
Insert
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Calibri
Rent Expense (per quarter)
Depreciation Expense (per quarter)
Draw
-
15 Shipping has been determined to be a mixed cost with the following total costs and units:
→
B
After analyzing expenses, the company has determined the following cost patterns.
Cost of Goods Sold (per unit)
$29.00
Sales Commissions (per dollar of sales)
9.50%
Administrative Salaries (per quarter)
$45,000
$27,000
$36,000
Formulas
24
25
25
26
27
28 use the data to answer the following
17,000
$48.00
C
Total Cost
$67,000
$94,000
$89,800
$92,600
M
Data
$72,500
$80,000
$84,000
$100,000
Units
12,500
21,000
13,800
20,000
D
13,700
14,000
14,300
22,500
E
G
H
Editing ✓
General
L
M
-0
.00
0](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2563bc6a-97bf-4929-a1e2-734eabab6125%2Ff6ab1bd5-86c0-486a-89a2-00423f04fbc8%2F3nyar0c_processed.jpeg&w=3840&q=75)
![34
35
36
1R x 8C
37
38
39
40
41
42
43
44
45
Dv
60
44
High level of activity
Low level of activity
Change in activity
variable cost per unit
Fixed cost portion:
Total cost at high level of activity
Less: Variable cost element
Total fixed cost
Cost of goods sold
Sales commissions
Shipping expense
55
56
57 Contribution margin
58
59
✓ ✓ Av.. Ev ab
X✓ fx Accessibility tab summary: Information about Jay Corporation is presented in row
C
J
Units
Total variable expenses
Calibri
46 2. Prepare a contribution margin income statement for Quarter 1 of 2024.
47
48
49
50
51
Sales
52 Variable expenses:
53
54
Fixed expenses:
Adminstrative salaries
Rent expense
B
11 v B
Total Cost
Jay Corporation
Budgeted Income Statement
For 2024, Quarter 1
D
E
G
H
+
I](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2563bc6a-97bf-4929-a1e2-734eabab6125%2Ff6ab1bd5-86c0-486a-89a2-00423f04fbc8%2Fliu79s_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)