ch10sweeneySTUDENT
.xlsx
keyboard_arrow_up
School
Hillsdale College *
*We aren’t endorsed by this school
Course
424
Subject
Accounting
Date
Jan 9, 2024
Type
xlsx
Pages
13
Uploaded by HighnessSeahorseMaster666
FileName: dbd0e27c88777c761fa095edd505336b73483d3e.xlsx, Tab: E10-5e4, Page 1 of 13, 12/15/2023,
19:38:06
Name:
Solution
Date:
Instructor:
Course:
EXERCISE 10-5. Sales Budget
Locksafe Company manufactures burglar-resistant commercial door locks. Recently, the company began
selling locks on the Web, and the company expects sales to increase dramatically compared with the prior
year. For the past year, 2011, unit sales were as follows:
First quarter
23,000 units
Second quarter
28,000 units
Third quarter
27,000 units
Fourth quarter
30,000 units
Required:
Assume that sales for each quarter in 2012 will be
25%
higher than they were in 2011 and the
selling price per lock is
$15
Prepare a sales budget.
Locksafe Company
Sales Budget
For the Year Ending December 31, 2012
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Year
Sales for 2011 in units
23,000
28,000
27,000
30,000
108,000
Projected sales at 125% of prior year
28,750
35,000
33,750
37,500
135,000
Sales price per unit
$15
$15
$15
$15
15
Budgeted revenue for 2012
$431,250
$525,000
$506,250
$562,500
2,025,000
Managerial Accounting
, 4th Edition by James Jiambalvo
Solving Managerial Accounting Problems Using Microsoft Excel
for Windows Templates
by Rex A Schildhouse
FileName: dbd0e27c88777c761fa095edd505336b73483d3e.xlsx, Tab: E10-5e4 ans, Page 2 of 13, 12/15/2023,
19:38:06
Name:
Solution
Date:
Instructor:
Course:
EXERCISE 10-5. Sales Budget
Locksafe Company manufactures burglar-resistant commercial door locks. Recently, the company began
selling locks on the Web, and the company expects sales to increase dramatically compared with the prior
year. For the past year, 2011, unit sales were as follows:
First quarter
23,000 units
Second quarter
28,000 units
Third quarter
27,000 units
Fourth quarter
30,000 units
Required:
Assume that sales for each quarter in 2012 will be
25%
higher than they were in 2011 and the
selling price per lock is
$15
Prepare a sales budget.
Locksafe Company
Sales Budget
For the Year Ending December 31, 2012
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Year
Sales for 2011 in units
23,000
28,000
27,000
30,000
108,000
Projected sales at 125% of prior year
28,750
35,000
33,750
37,500
135,000
Sales price per unit
$15
$15
$15
$15
$15
Budgeted revenue for 2012
$431,250
$525,000
$506,250
$562,500
$2,025,000
Managerial Accounting
, 4th Edition by James Jiambalvo
Solving Managerial Accounting Problems Using Microsoft Excel
for Windows Templates
by Rex A Schildhouse
Production Budget
Data:
Jan
Feb
Mar
Apr
Expected Sales (units)
13,000
14,900
19,400
21,900
Inventory, Jan 1 (units)
1,300
Desired ending inventory
10% of following month's expected sales
VitaPup
Production Budget
Month
Jan
Feb
Mar
Total for the Quarter
Current month requirement
13,000
14,900
19,400
47,300
add desired ending inventory
1,490
1,940
2,190
2,190
Total required
14,490
16,840
21,590
49,490
Less beginning inventory
1,300
1,490
1,940
1,300
Required Production
13,190
15,350
19,650
48,190
Ex 10-7e4
Production Budget
Data:
Jan
Feb
Mar
Apr
Expected Sales (units)
13,000
14,900
19,400
21,900
Inventory, Jan 1 (units)
1,300
Desired ending inventory
10% of following month's expected sales
VitaPup
Production Budget
Month
Jan
Feb
Mar
Total
Current month requirement
13,000
14,900
19,400
47,300
add desired ending inventory
1,490
1,940
2,190
2,190
Total required
14,490
16,840
21,590
49,490
Less beginning inventory
1,300
1,490
1,940
1,300
Required Production
13,190
15,350
19,650
48,190
FileName: dbd0e27c88777c761fa095edd505336b73483d3e.xlsx, Tab: E10-8e4 , Page 5 of 13, 12/15/2023, 19:38:06
Exercise E10-8 Direct Materials Purchases Budget
Roehler Industrial has estimated that production for the next five quarters will be:
Production Information
Quarter 1, 2011
45,000 units
Quarter 2, 2011
41,000 units
Quarter 3, 2011
49,000 units
Quarter 4, 2011
38,000 units
Quarter 1, 2012
47,000 units
Finished units of production require
6
pounds of raw material per unit. The raw material cost
is
$5.00
per pound. There are
54,000
pounds of raw material on hand at the beginning of
quarter 1, 2011. Roehler desires to have
20%
of next quarter's material requirements on hand at the
end of each quarter.
Required:
Prepare quarterly direct materials purchases budgets for Roehler Industries for 2011.
ROEHLER INDUSTRIES
Direct Materials Purchases Budget
For the Year Ending December 31, 2011
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
Meman
arrow_forward
Haresh
arrow_forward
When a company has post-acquisition expenditures related to Property, Plant, and Equipment it must determine whether the amount
should be expensed as an ordinary repair or capitalized as a major repair, addition, or betterment. This requires considering the nature
of the expenditure and the use of judgment.
Many companies use a threshold amount. Any expenditure below the threshold is expensed. Items over the threshold are examined
and a decision is made about whether to expense or capitalize the item. This approach is justified by both materiality and considering
costs and benefits. For example, a company with $94 million in net property, plant, and equipment and $250 million of operating
expenses would not consider a $100 repair as material. Plus, if the company had to spend thousands of dollars examining every repair
expenditure, the costs of doing the analysis could easily outweigh the benefits.
SouthEast Equipment has a large number of machines and equipment that are available for…
arrow_forward
Please help with all answers.....part a part b and part c
arrow_forward
Proctoring Enable X
brewer5ce_exhibit10_2.jpg (795 X
> brewer5ce_exhibit10_1.jpg (683
+
0
getproctorio.com/secured #lockdown
toring Enabled: Assignment 4 i
Saved
2
The Engine Guys produces specialized engines for "snow climber" buses. The company's normal monthly production volume is 7,000
engines, whereas its monthly production capacity is 14,000 engines. The current selling price per engine is $1,100. The cost per unit of
manufacturing and marketing the engines at the normal volume is as follows:
Costs per
Unit for
Engines
00:54:56
eBook
Manufacturing costs:
Direct materials
Direct labour
$ 100
176
Variable overhead
30
Fixed overhead
176
Subtotal
$ 482
Marketing costs:
Variable
Fixed
Subtotal
Total unit cost
$ 55
121
176
$ 658
Mc
Graw
Hill
ming
ngs
Required:
Answer the following independent questions.
1-a. The Provincial Bus Company wishes to purchase 700 engines in October. The bus company is willing to pay a fixed fee of
$840,000 and reimburse The Engine Guys for all manufacturing…
arrow_forward
Give me answer within 30 min please I will give you immediately upvotes its very urgent ...thanku ...
arrow_forward
engageNOWv2 | Online teach x
+
n/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
O SOFTWARE UPDATE
34m
macOS Big Sur 11.3.1 is available and will be instal
later tonight.
еBook
E Print Item
Single plantwide factory overhead rate
Bach Instruments Inc. makes three musical instruments: flutes, clarinets, and oboes. The budgeted factory overhead cost is $88,320. Overhead is allocated to the three
products on the basis of direct labor hours. The products have the following budgeted production volume and direct labor hours per unit:
Budgeted Production
Direct Labor Hours Per
Volume
Unit
Flutes
2,600 units
0.4
Clarinets
600
1.6
Oboes
1,400
1.2
If required, round all per unit answers to the nearest cent.
a. Determine the single plantwide overhead rate.
X per direct labor hour
b. Use the overhead rate in (a) to determine the amount of total and per-unit overhead allocated to each of the three products.
Total
Per Unit
Factory Overhead Cost
Factory…
arrow_forward
[1stITEM] refer to the photo below
arrow_forward
Help please with right answer
arrow_forward
Answer the following according to the following format
arrow_forward
NOWV2 | Online teach x
+
O SOFTWARE UPDATE
eAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress%3false
macOS Big Sur 11.3.1 is available and will be in
later tonight.
O eBook
Show Me How
E Print Item
Activity-Based Costing: Factory Overhead Costs
The total factory overhead for Bardot Marine Company is budgeted for the year at $1,167,450, divided into four activities: fabrication, $507,000; assembly, $210,000;
setup, $245,700; and inspection, $204,750. Bardot Marine manufactures two types of boats: speedboats and bass boats. The activity-base usage quantities for each
product by each activity are as follows:
Fabrication
Assembly
Setup
Inspection
Speedboat
9,750 dlh
31,500 dlh
70 setups
122 inspections
Bass boat
29,250
10,500
515
853
39,000 dlh
42,000 dlh
585 setups
975 inspections
Each product is budgeted for 5,500 units of production for the year.
a. Determine the activity rates for each activity.
Fabrication
$
per direct labor hour
Assembly
5
V per…
arrow_forward
ENOWV2 | Online teachin X
eAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
Requiem:.
a Britten's War Requi...
eBook
Show Me How
Calculator
Fresno Industries Inc. manufactures and sells high-quality camping tents. The company began operations on January 1 and operated at 100% of
capacity (150,000 units) during the first month, creating an ending inventory of 20,000 units. During February, the company produced 130,000 units
during the month but sold 150,000 units at $500 per unit. The February manufacturing.costs and selling and administrative expenses were as
follows:
Number of
Unit
Total
Units
Cost
Cost
Manufacturing costs in February 1 beginning inventory:
Variable
20,000
$275.00
$5,500,000
Fixed
20,000
26.00
520,000
Total
$301.00
$6,020,000
Manufacturing costs in February:
Variable
130,000
$275.00
$35,750,000
Fixed
130,000
30.00
3,900,000
Total
$305.00
$39,650,000
Selling and administrative expenses in February:
Variable
150,000
$20.00…
arrow_forward
Prepare a one-page summary/recommendation on your reading of the case.
arrow_forward
Haresh
arrow_forward
Engery Cost Savings (Green Computing)
The below data represents cost (expenses) and savings for Thom-Pierre Consultants (TPC) for all organizational computer use for 2018 and 2019. TPC implemented a green computer initiative in January 2019.
Operating Cost
Computer type
General Computer Use (2018)
Green Computer Use (2019)
Savings
Notebook Dual Core
17490
9500
Notebook Quad Core
21000
12500
PC Dual Core
34500
21200
PC Core Duo
42000
21450
Servers Core Duo
25000
16550
Servers 4 Core Duo
30000
12450
Total
arrow_forward
View Policies
Current Attempt in Progress
E-Flix rents DVDS that are mailed out to customers upon demand. E-Flix has identified three activities involved in getting the videos to its
customers. Information on those activities for the month of July follows:
Estimated
Expected Use of
Cost Drivers
Cost Pools
Cost Drivers
Overhead Cost
Order taking costs
Number of orders
$20,592
187,200 orders
Technology support
Number of minutes
$11,700
234,000 minutes
Picking and shipping
Number of DVDS
$39,624
330,200 DVDS
costs
During July, the Tucker family placed 17 orders consisting of 21 DVDs. Tucker required 7 minutes of tech support. Customers pay $9.00 per
month to rent unlimited DVDS. Using ABC, how much overhead is applied to the Tucker family account for order taking costs?
O $4.74
O $2.52
O $1.871
O $6.45
Submit Answer
Save for Later
Attempts: 0 of 1 used
2:27 PM
10/13/20
e
arrow_forward
Before you begin this assignment review the Tying It All Together feature in the chapter.
Best Buy Co., Inc. is a leading provider of technology products. Customers can shop at more than 1,700 stores or online. The company is also known for its Geek Squad for technology services. Suppose Best Buy is considering a particular HDTV for a major sales item for Black Friday, the day after Thanksgiving, known as one of the busiest shopping days of the year. Assume the HDTV has a regular sales price of $900, a cost of $500, and a Black Friday proposed discounted sales price of $650. Best Buy’s 2015 Annual Report states that failure to manage costs could have a material adverse effect on its profitability and that certain elements in its cost structure are largely fixed in nature. Best Buy, like most companies, wishes to maintain price competitiveness while achieving acceptable levels of profitability. (Item 1A. Risk Factors.)
Requirements
Calculate the gross profit of the HDTV at the regular…
arrow_forward
Nikul
Don't upload image please
arrow_forward
please describe this question in step wise
arrow_forward
https://education.aima.in/processOnlineExam.action?onlineAssignmentDefinition.id 1444118538- Google Chrome
A education.aima.in/processOnlineExam.action?onlineAssignmentDefinition.id=1444118538
A company produces X, Y and Z from a raw material M. For every 100 tonnes ofM put into production it obtains 50 tons of product X, 30 tons of Y and 15
tons of Z, while 5 tons goes as waste. The selling price of X, Y and z is Rs. 40. Rs, 60 and Rs. 80 per ton. The cost of raw material M is Rs. 20 and variable
processing costs are Rs. 10. Variable marketing costs are budgeted to be at the rate of 10 percent of sales value. Budgeted fixed overheads per annum are:
Manufacturing - Rs. 40,000, Marketing - Rs. 30,000, and Administration - Rs. 20,000. The company intends to process 10,000 tonnes of material M in the
coming year.
or
Question 21:- Fixed Cost is Rs.
a) O 75000
b) O 60000
E
c)
90000
d) O 55000
TH
NO
Question 22:- Contribution is Rs.
a) O 12 per unit
b) . 15 per unit
F
c)O 16 per unit
d) O 18…
arrow_forward
8:48 ..l
82
bartleby.com
= bartleby
Q&A Sign in
Business / Accounting / Q&A Library / Exercise 3 (M...
Exercise 3 (Make or Buy a Compone...
Start your trial now! First week
$4.99!
nly
->
Question
Exercise 3 (Make or Buy a Component)
Cañada Inc., manufactures a variety of heating and air-conditioning units.
The company is currently manufacturing all of its own component parts. An
outside supplier has offered to sell a thermostat to Cañada for P200 per unit.
To evaluate this offer, Cañada, Inc., has gathered the following information
relating to its own cost of producing the thermostat internally:
Per
15,000 Units
_per Year
P 900,000
1,200,000
150,000
750,000
Unit
P60
Direct materials
Direct labor
Variable manufacturing overhead.
Fixed manufacturing overhead, traceable
Fixed manufacturing overhead, common, but
allocated.
Total cost..
80
10
50*
100
P300
1,500,000
P4,500,000
• 40% supervisory salaries; 60% depreciation of special equipment (no resale
value).
Required:
1. Assuming that the…
arrow_forward
Help please
arrow_forward
Continue:
BFIN 300 Fal X
M Inbox (11,43 X
Week 4, We
Do/Con
A https://blackboard.albany.edu/webapps/assessment/take/take.jsp?course_assessment id=_152523 1&course_id= 157898 1&content id= 60538.
To
How To Factory Res..
O Honey
P MyLab IT | Pearson M Inbox (10,367) - rde.
Ot
WN. CPU.
Google WebAssign - Blackboard Learn
K.J. Lee, CFA, an analyst with
Water's Edge
Securities, estimates the
market risk premium is 6.80%
and the risk-free rate is
2.10%. She's calculated the
beta for Summerfield Tech as
0.94, and she estimates the
expected return is:
O Type here to search
5:54 PM
10/25/2021
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Service department charges and activity bases
Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service
categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October.
Budgeted Activity
CCS Service Category
Activity Base
Budgeted Cost
Base Quantity
Help desk
Number of calls
$170,000
3,400
Network center
Number of devices monitored
824,000
10,300
Electronic mail
Number of user accounts
88,200
9,800
Number of handheld devices
Handheld Technology support
118,300
9,100
issued
One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector:
• The sector has 4,800 employees, of whom 35%…
arrow_forward
In Principles of Accounting:
12th Edition
Belverd E. + 5 others
Publisher: Cengage Learning
ISBN: 9781133593102
Please answer part three.
arrow_forward
Edwards Ltd
The next client Wayne tells you about is Edwards Ltd, where Wayne is evaluating the internal controls in the sales and receivables areas. Edwards manufactures small scale water purifiers which are then sold to retailers, with a year ending 30 June 2021. Wayne has identified the following internal control procedures.
All sales are made on credit, with outstanding accounts due and payable within 30 days. Customers can purchase the water purifiers from Edwards by emailing or telephoning through their purchase order. Immediately on receipt of a customer’s request, a sales clerk prepares a sales order.
Sales orders are manually pre-numbered and produced in triplicate. One copy of the sales order is sent to the shipping department, one to the invoicing department and one copy is filed in the sales department.
On receipt of the sales order by the shipping department, the shipping clerk obtains the items from the warehouse, packages them, prepares a shipping note and arranges…
arrow_forward
Wv2 | Online teachin X +
takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession
Locator=&inprogress... A
The following events took place for Technology Treasures Manufacturing Company during January, the first month of its operations as a produ
digital video monitors:
a. Purchased $138,600 of materials.
b. Used $93,540 of direct materials in production.
c. Incurred $182,560 of direct labor wages.
d. Incurred $213,040 of factory overhead.
e. Transferred $426,220 of work in process to finished goods.
f. Sold goods for $660,000.
g. Sold goods with a cost of $367,500.
h. Incurred $86,200 of selling expense.
i. Incurred $70,250 of administrative expense.
Required:
Using the information given, complete the following:
a. Prepare the January income statement for Technology Treasures Manufacturing Company. Be sure to complete the statement
heading. Refer to the lists of Accounts, Labels and Amount Descriptions list provided for the exact wording of the answer choices for text…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Memanarrow_forwardHaresharrow_forwardWhen a company has post-acquisition expenditures related to Property, Plant, and Equipment it must determine whether the amount should be expensed as an ordinary repair or capitalized as a major repair, addition, or betterment. This requires considering the nature of the expenditure and the use of judgment. Many companies use a threshold amount. Any expenditure below the threshold is expensed. Items over the threshold are examined and a decision is made about whether to expense or capitalize the item. This approach is justified by both materiality and considering costs and benefits. For example, a company with $94 million in net property, plant, and equipment and $250 million of operating expenses would not consider a $100 repair as material. Plus, if the company had to spend thousands of dollars examining every repair expenditure, the costs of doing the analysis could easily outweigh the benefits. SouthEast Equipment has a large number of machines and equipment that are available for…arrow_forward
- Please help with all answers.....part a part b and part carrow_forwardProctoring Enable X brewer5ce_exhibit10_2.jpg (795 X > brewer5ce_exhibit10_1.jpg (683 + 0 getproctorio.com/secured #lockdown toring Enabled: Assignment 4 i Saved 2 The Engine Guys produces specialized engines for "snow climber" buses. The company's normal monthly production volume is 7,000 engines, whereas its monthly production capacity is 14,000 engines. The current selling price per engine is $1,100. The cost per unit of manufacturing and marketing the engines at the normal volume is as follows: Costs per Unit for Engines 00:54:56 eBook Manufacturing costs: Direct materials Direct labour $ 100 176 Variable overhead 30 Fixed overhead 176 Subtotal $ 482 Marketing costs: Variable Fixed Subtotal Total unit cost $ 55 121 176 $ 658 Mc Graw Hill ming ngs Required: Answer the following independent questions. 1-a. The Provincial Bus Company wishes to purchase 700 engines in October. The bus company is willing to pay a fixed fee of $840,000 and reimburse The Engine Guys for all manufacturing…arrow_forwardGive me answer within 30 min please I will give you immediately upvotes its very urgent ...thanku ...arrow_forward
- engageNOWv2 | Online teach x + n/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false O SOFTWARE UPDATE 34m macOS Big Sur 11.3.1 is available and will be instal later tonight. еBook E Print Item Single plantwide factory overhead rate Bach Instruments Inc. makes three musical instruments: flutes, clarinets, and oboes. The budgeted factory overhead cost is $88,320. Overhead is allocated to the three products on the basis of direct labor hours. The products have the following budgeted production volume and direct labor hours per unit: Budgeted Production Direct Labor Hours Per Volume Unit Flutes 2,600 units 0.4 Clarinets 600 1.6 Oboes 1,400 1.2 If required, round all per unit answers to the nearest cent. a. Determine the single plantwide overhead rate. X per direct labor hour b. Use the overhead rate in (a) to determine the amount of total and per-unit overhead allocated to each of the three products. Total Per Unit Factory Overhead Cost Factory…arrow_forward[1stITEM] refer to the photo belowarrow_forwardHelp please with right answerarrow_forward
- Answer the following according to the following formatarrow_forwardNOWV2 | Online teach x + O SOFTWARE UPDATE eAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress%3false macOS Big Sur 11.3.1 is available and will be in later tonight. O eBook Show Me How E Print Item Activity-Based Costing: Factory Overhead Costs The total factory overhead for Bardot Marine Company is budgeted for the year at $1,167,450, divided into four activities: fabrication, $507,000; assembly, $210,000; setup, $245,700; and inspection, $204,750. Bardot Marine manufactures two types of boats: speedboats and bass boats. The activity-base usage quantities for each product by each activity are as follows: Fabrication Assembly Setup Inspection Speedboat 9,750 dlh 31,500 dlh 70 setups 122 inspections Bass boat 29,250 10,500 515 853 39,000 dlh 42,000 dlh 585 setups 975 inspections Each product is budgeted for 5,500 units of production for the year. a. Determine the activity rates for each activity. Fabrication $ per direct labor hour Assembly 5 V per…arrow_forwardENOWV2 | Online teachin X eAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false Requiem:. a Britten's War Requi... eBook Show Me How Calculator Fresno Industries Inc. manufactures and sells high-quality camping tents. The company began operations on January 1 and operated at 100% of capacity (150,000 units) during the first month, creating an ending inventory of 20,000 units. During February, the company produced 130,000 units during the month but sold 150,000 units at $500 per unit. The February manufacturing.costs and selling and administrative expenses were as follows: Number of Unit Total Units Cost Cost Manufacturing costs in February 1 beginning inventory: Variable 20,000 $275.00 $5,500,000 Fixed 20,000 26.00 520,000 Total $301.00 $6,020,000 Manufacturing costs in February: Variable 130,000 $275.00 $35,750,000 Fixed 130,000 30.00 3,900,000 Total $305.00 $39,650,000 Selling and administrative expenses in February: Variable 150,000 $20.00…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you