DB3 Cost Price and Viability v12 - Assignment
xlsx
keyboard_arrow_up
School
Kirinyaga University College (JKUAT) *
*We aren’t endorsed by this school
Course
6016
Subject
Finance
Date
Nov 24, 2024
Type
xlsx
Pages
5
Uploaded by DeaconPower11250
FINA6016
DROPBOX 3 - EXPORT COSTING, PRICING & TRANSACTION VIABILITY
v12
Submitted to:
Katsademas
Your Role:
Tasks
Seven tasks to complete
1
Identify your group members
2
maximum of 2 members
What is your INCO term?
NAME
Student ID
One Jane Dow
1234568
Two Jane Dow
7654321
3
Incorporate the following eight parameters
Your calculations from the costing sheet will provide
into the Costing Sheet (next worksheet)
the answers to tasks 4, 5 and 6.
Note: Only the following eight entries are to be entered in the worksheet.
All other lines are to remain blank.
4
3.1
Domestic cost of LAV
$ 5,485,000 3.2
Modifications reguired in order to
Comply with EU safety standards
5
$ 3,640,000 3.3
Transportation costs (pick the method)
Pick between AIR:
$ 27,600 per flight hour
$ 192 per mile flown
Or LAND/SHIP:
$ 224 per nautical mile
$ 66 per road km
3.4
Insurance is based on
115% of CFR cost
6
with a rate of
0.075%
3.5
Freight Forwarding fees
$ 464,750.00 3.6
Import Taxes
100% of CIP cost
Based on the information you now have
with a rate of
6.510%
answer question 7.
3.7
Export Credit Insurance is based on
7
Is this a viable transaction? Explain
100% of CIP cost
with a rate of
19.470%
3.8
Profit Margin needs to be
10.1500% of Export Sales Price
You represent GDLS. GDLS is negotiating with the Republic of Lithuania the sale of the GDLS LAV700.
Complete the SEVEN tasks below. Note that Task #3 has 8 components.
Completion of these tasks allow you to:
calculate the export costs of sending the LAV700 to Lithuania
determine the export price to make the desired profit and
explain if this is a viable transaction or not depending on the selected INCO
term (Task #2)
What is your Export Cost
(in $)?
Taken into account?
What is your Profit Margin
(in $)?
What is your Export Sales Price
?
Categories Items
EXPORT COSTIN
1. Product costs Domestic Cost: Raw materials
Cost/Unit
Domestic Cost: Direct labour Units
General manufacturing expenses Sales
Modification costs
Profit
Administration Domestic financing fees COSTS
SALE PRICE
Total Product cost xxxxxxx $ - $ - Less taxes refunded 2. Costs of sales and promotion Travel expenses $ 56,444,232.00 Promotional activities Communications Translation Legal and negotiating expenses Export sales commissions Total Cost of sales and promotion
xxxxxxx $ 56,444,232.00 $ 56,444,232.00 3. Preparation for transport Labelling Export packing Marking cases Strapping costs Total COST EXW xxxxxxx $ 56,444,232.00 $ 56,444,232.00 4. Other costs of preparation for transport Consular invoices
Other documents Freight forwarders fees Insurance Total cost (ready for transport) xxxxxxx $ 56,444,232.00 $ 56,444,232.00 5. Inland transportation costs Loading charges Transport to main carriage Tailgating (maritime) Unloading charges Total COST FCA
xxxxxxx $ 56,444,232.00 $ 56,444,232.00 6. Port charges and loading Demurrage and storage Wharf charges
Loading onto vessel
Other charges Total COST FOB xxxxxxx $ 56,444,232.00 $ 56,444,232.00 7. Main carriage Freight
Miscellaneous Total COST CFR xxxxxxx $ 56,444,232.00 $ 56,444,232.00 8. Insurance coverage Insurance of goods (usually 110% of value)
Total COST CIP
xxxxxxx $ 56,444,232.00 $ 56,444,232.00 9. Unloading charges (these are usually included in the ocean freight cost) Unloading Other special charges $ 34,444.00 Storage 10. Import duties and delivery
Import taxes (duties) Broker’s fees Delivery to client Loading
Transport to main carriage Total COST DDP
xxxxxxx $ 56,478,676.00 $ 56,478,676.00 11. Export financing costs (incurred for all INCO terms)
Financial instruments ( such as letters of Credit)
Discounting charges
Export Credit insurance
Hedging of foreign exchance risk
xxxxxxx $ 56,478,676.00 $ 56,478,676.00 Export SALES PRICE
xxxxxxx $ 56,478,676.00 EXPORT COST - before profit margin
Profit margin
(as a % of export sales price
)
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
NG SHEET
56,478,676 1 56,478,676 - Sale/Unit
$ - $ 56,444,232.00 $ 56,444,232.00 $ 56,444,232.00 $ 56,444,232.00 $ 56,444,232.00 $ 56,444,232.00 $ 56,444,232.00
$ 56,478,676.00 $ 56,478,676.00 $ 56,478,676.00
Related Documents
Related Questions
1. Assign Overhead Costs to Activity Cost Pools
国日
First-Stage Allocation to Activity Cost Pools - Excel
Sign In
FILE
HOME
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Calibri
-A A
10
Paste
BIU
- A -
Alignment Number
Conditional Format as
Cell
Cells
Formatting - Table - Styles -
Clipboard
Font
Styles
A1
fx
A
C
E
F
G
1
==
2 Total costs and distribution of resource consumption across activity cost pools:
3
4
Activity Cost Pools
Customer
Product
Customer
Total Cost
Orders
Development
Relations
Other
Total
6 Production Department:
7
Indirect factory wages
$
400,000
50%
30%
15%
5% 100%
Factory equipment depreciation
Factory utilities
10 Factory property taxes and insurance
8
150,000
55%
30%
0%
15% 100%
9
120,000
59%
34%
0%
7%
100%
75,000
57%
33%
0%
10%
100%
11
12 General Administrative Department:
Administrative wages and salaries
Office equipment depreciation
13
275,000
20%
10%
40%
30% 100%
14
40,000
32%
16%
15%
37%
100%
15
Administrative property taxes and insurance
60,000
0%
0%
0%
100%…
arrow_forward
ctoring Enabled: Chapter 3 Linear Programming.. 6
Saved
Help
Save &
1
A plumbing repair company has 9 employees and must choose which of 9 jobs to assign each to (each employee is assigned to
exactly one job and each job must have someone assigned).
a. How many decision variables will the linear programming model include?
Number of decision variables
b. How many fixed requirement constraint will the linear programming model include?
Number of fixed requirement constraints
arrow_forward
Tutorial 8 - Managerial Accounting - Word
zatimxiz@gmail.com
File
Mailings
View
Help
O Tell me what you want to do
& Share
Home
Insert
Design
Layout
References
Review
X Cut
P Find -
Tahoma
11
-A A Aa -
AaBbCcDc AaBbCcDc AaBbC AaBbCcC AaB AaBbccC AqBbCcD
E Copy
abe Replace
Paste
в IU -abe X, X*
A - aly ,
I Normal
I No Spac. Heading 1 Heading 2
Title
Subtitle
Subtle Em..
Format Painter
A Select -
Clipboard
Font
Paragraph
Styles
Editing
QUESTION 1
E19.5 (Рg. 19-31)
E19.5 (LO 2) Gala Company is a manufacturer of laptop computers. Various costs
and expenses associated with its operations are as follows.
Classify various costs into different cost categories.
1. Property taxes on the factory building.
2. Production superintendents' salaries.
3. Memory boards and chips used in assembling computers.
4. Depreciation on the factory equipment.
5. Salaries for assembly-line quality control inspectors.
6. Sales commissions paid to sell laptop computers.
7. Electrical components used in assembling…
arrow_forward
Activity - Cost According to Cost behavior - ACT 204 - Word
Arriane trillanes
AT
File
Home
Insert
Design
Layout
References
Mailings
Review
View
Help
O Tell me what you want to do
& Share
X Cut
• Find -
Calibri
- 11
A A
Aa -
AaBbCcDc AaBbCcDc AaBbCcDc AaBbCcDc AaBbCcDc AaBbCcDc AaBbCcl
De Copy
Paste
a. Replace
BI U - abe x
A -
aly
I Normal
T Body Text T List Para. T No Spac. T Table Pa. T Heading 1 Heading 2
V Format Painter
Select -
Clipboard
Font
Paragraph
Styles
Editing
Segregation of Mixed Costs
3. Charity Company wants to analyze the behavior of its selling costs for budgeting purposes. Cost drivers
(activity measures) and costs incurred in the first quarter and the first month of the second quarter are as
follows:
January
February
March
April
Selling costs:
Sales salaries
P 42.500
P 42,500
P 42,500
14,000
32,400
P51,000
16,000
35,600
Commissions
15,000
34,000
17,500
38,000
Shipping costs
Advertising
20,000
Full 20,000 Snip 25,000
20,000
Cost drivers:
280,000
28,000
Peso sales…
arrow_forward
S Module Three Assignment - ACC X
CengageNOWv2 | Online teachir x +
gagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogre..
еВook
Show Me How
Cost Flow Methods
The following three identical units of Item K113 are purchased during April:
Item Beta
Units
Cost
April 2
Purchase
1
$171
April 15
Purchase
1
175
April 20
Purchase
1
179
3
$525
Total
Average cost per unit
$175
($525 + 3 units)
Assume that one unit is sold on April 27 for $247. Determine the gross profit for April and ending inventory on April 30 using the (a) first-in, first-out
(FIFO); (b) last-in, first-out (LIFO); and (c) weighted average cost method.
Gross Profit
Ending Inventory
a. First-in, first-out (FIFO)
b. Last-in, first-out (LIFO)
c. Weighted average cost
Previous
Next>
Check My Work
6:38 AM
45°F
A D E a O A 40)
11/13/2021
arrow_forward
ples of Managerial Acco
M Question 1- Comprehensive P
X +
ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Flms.mheducation.com%252Fmghmiddleware%252Fmhepro
Comprehensive Problem 5
Saved
1
Part 1 of 6
04:02:14
eBook
Print
References
Required information
[The following information applies to the questions displayed below.]
Jasper Company, a machine tooling firm, has several plants. One plant, located in Saint Cloud, Minnesota, uses a job order
costing system for its batch production processes. The Saint Cloud plant has two departments through which most jobs
pass. Plantwide overhead, which includes the plant manager's salary, accounting personnel, cafeteria, and human
resources, is budgeted at $250,000. During the past year, actual plantwide overhead was $242,000. Each department's
overhead consists primarily of depreciation and other machine-related expenses. Selected budgeted and actual data from
the Saint Cloud plant for the past year…
arrow_forward
Accounting excel practice problem - I already solved the first few sub parts to this question - I just need the last sub part answered. I attached a picture of the instructions and a picture of the excel spreadsheet to answer the remaining "formulas".
arrow_forward
Could you help me find the activity cost per unit
arrow_forward
O Zoom Meeting
You are viewing Rinki Maheshwari's screen
View Options -
Original Sound: Off
* View
DzL Chapter 6- Marginal costing x
O Post Attendee - Zoom
M Inbox (2,520) - rinkimahesh x
O Dashboard - TimeClockWiz x
O Managerial Accounting.pdf x
O Dashboard - Instructor
+
i eastwestcollege.brightspace.com/d21/le/content/7747/viewContent/28312/View
Error
Prepared by- Aradhana Khera
4. From the following information, find out sales at BEP in units.
Variable cost per unit = $15
Sales per unit = $20
Fixed expenses = $54,000
Solution-
Contribution per unit = SP per unit - VC per unit= 20-15= $5
BEP IN UNITS = FC/CONTRIBUTION PER UNIT
= 54000/5
ull Rinki Maheshwari
= 10,800 UNITS
5. Calculate (i) BEP, and (ii) Margin of Safety based on the following
information:
Sales = $100,000
Total cost = $80,000
Fixed cost = $20,000
Net profit = 80,000
A Download
A Print
• 24
Leave
Unmute
Start Video
Participants
Chat
Share Screen
Record
Reactions
ENG
10:16 AM
令中
28
2022-03-04
US
arrow_forward
M (no subject) - redmond.vicki@gn X
A Role of Cost in Managerial Accou X
D Question 4 - Practice Exam 1 - C x+
Ô https://ezto.mheducation.com/ext/map/index.html?_con3Dcon&external_browser%3D0&launchUrl=https%253A%252F%252Fnewconnect.m
Saved
H
kam 1 G
Identify each of the preceding costs as either a product or a period cost. If the cost is a product cost, decide whether it is for
direct materials (DM), direct labor (DL), or manufacturing overhead (MOH) and also identify each of the preceding costs as
variable or fixed cost. (Select "NA" wherever necessary.)
Cost
Costs
Type of cost
Cost head
classification
Product
Factory rent
Company advertising
Wages paid to assembly workers
Depreciation for salespersons' vehicles
Screws
Period
Product
Period
Product
Product
Product
Utilities for factory
Assembly supervisor's salary
Sandpaper
President's salary
Plastic tubing
Product
Period
Product
Product
Period
Paint
Sales commissions
Factory insurance
Depreciation on cutting machines
Wages paid to…
arrow_forward
E S2 Project Management.pdf
DF S3 Product design pdf
S3A Learning curves.pdf
A 54 Process analysis & job desı X
Fosya | C:/Users/alzey/Desktop/Fundamentals%20of%20Production%20Management/S1%20OM%20concepts%20and%20operatio..
O E A) Sesli oku
V Çız v
9 Vurgula v
O Sil
A U.S. MANUFACTURING COMPANY OPERATINGA SUBSIDIARY IN AN LDC (LESS
DEVELOPED COUNTRY) SHOWS THE FOLLOWING RESULTS:
LDC
20 000
U.S.
100 000
SALES (UNITS)
LABOR (HOURS)
RAW MATERIALS (CURRENCY)
CAPITAL REQUIREMENTS (HOURS)
20 000
15 000
$20 000
FC 20 000
60 000
5 000
A) CALCULATE PARTIAL LABOR PRODUCTIVITY AND CAPITAL PRODUCTIVITY
FIGURES FOR THE PARENT AND SU BSIDIARY. DO THE RESULTS SEEM
MISLEADING?
B) NOW COMPUTE THE MULTIFACTOR PRODUCTIVITY FIGURES FOR LABOR
AND CAPITAL TOGETHER. ARE THE RESULTS BETTER?
C) FINALLY, CALCULATE RAW MATERIAL PRODUCTIVITY FIGURES (UNIT/S
WHERE $1 = FC 10). EXPLAIN WHY THESE FIGURES MIGHT BE GREATER IN THE
SUBSIDIARY.
aya yazin
arrow_forward
ivity Based Costing Assignment i
nces
s://ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https... Al
A" ☆
aw
71
N
F2
Ly Homework: Activity Based Costin X
Required information
[The following information applies to the questions displayed below.]
#
3
Part Z
Part X
Totals
E
Textra produces parts for a machine manufacturer. Parts go through two departments, Molding and Trimming.
The company budgets overhead cost of $265,000 in the Molding department and $225,000 in the Trimming
department. The company budgets 16,000 machine hours (MH) in Molding and 25,000 direct labor hours
(DLH) in Trimming. Actual production information follows.
Number of
Units
3,000
4,000
F3
Complete this question by entering your answers in the tabs below.
R
F4
Q Search
%
Molding Department
Hours per Unit
2.0 MH per unit
2.5 MH per unit
Required:
1. Compute a departmental overhead rate for the Molding department based on machine hours and a departmental ove
rate for the Trimming…
arrow_forward
Smoky Mountain Corporation makes two types of hiking boots-the Xtreme and the Pathfinder. Data concerning these two product
lines appear below:
Xtreme
$ 121.00
$ 64.70
$ 10.80
Pathfinder
Selling price per unit
Direct materials per unit
Direct labor per unit
Direct labor-hours per unit
Estimated annual production and sales
$ 88.00
$ 54.00
%24
9.00
1.0 DLHS
71,000 units
1.2 DLHS
25, 000 units
The company has a traditional costing system in which manufacturing overhead is applied to units based on direct labor-hours. Data
concerning manufacturing overhead and direct labor-hours for the upcoming year appear below:
Estimated total manufacturing overhead
Estimated total direct labor-hours
$ 2,020,000
101,000 DLH5
Required:
1. Compute the product margins for the Xtreme and the Pathfinder products under the company's traditional costing system.
2. The company is considering replacing its traditional costing system with an activity-based costing system that would assign its
manufacturing…
arrow_forward
plz solve with explanation within 30-40 min and get multiple upvotes
arrow_forward
Cs Cases
1. Create a new Excel sheet in which you will find the delivery cost for each delivery.
nal...
a. Create a new sheet that has information for each delivery. Name this sheet "lookup."
Rat...
b. In this lookup sheet, look up the hourly rate for the driver for each delivery. Do not enter this information manually! Use the VLOOKUP function.
c. For each delivery, calculate the delivery cost as hourly rate for the driver multiplied by time (hours).
Fill in the table below for the first ten records.
Date
Delivery ID
Driver
Time (Hours)
Hourly Rate
Cost
20.00 X
1
George
1
1/1
25.00 X
2
Deanna
1.5
1/2
2
3
Ben
1/3
4
Caroline
2
1/3
<
5
Unknown
1
1/4
6
Elizabeth
2
1/5
7
Unknown
2.5
1/5
8
Unknown
1
1/6
9
Adam
2
1/8
10
Hannah
1.5
1/9
2. Create a new Excel sheet that aggregates the data contained in the lookup sheet to show each driver's activity analysis.
a. Create a pivot table in a new sheet; name this new sheet "pivot table."
arrow_forward
Directions
1
Given
cose =
2, and is in Quadrant 1, what is tane?
You must show all of your work to receive credit for this problem.
Please choose one option to complete this activity.
Sketchpad
FILE UPLOAD i
Question 7
OR
1
File Upload
Upload your work. Show all steps to receive credit for this problem.
arrow_forward
E Managerial Accountin x
B 3-1 Problem Set: Mod X
* CengageNOWv2 |On x
b My Questions | bartlel x
* Cengage Learning
Cengage Learning
+
A v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
Update :
Problem Set: Module 6
O eBook
I Show Me How
1. EX.07.02.ALGO
Income Statements under Absorption Costing and Variable Costing
Gallatin County Motors Inc. assembles and sells snowmobile engines. The company began operations on July 1 and operated at 100% of capacity during
2. TMM.07,01
the first month. The following data summarize the results for July:
3. EX.07.12.ALGO
Sales (18,500 units)
$2,405,000
Production costs (24,000 units):
4. EX.07.05.ALGO
Direct materials
$1,154,400
5. TMM.07.05
Direct labor
554,400
Variable factory overhead
276,000
Fixed factory overhead
184,800
2,169,600
Selling and administrative expenses:
Variable selling and administrative expenses
$336,300
Fixed selling and administrative expenses
130,200
466,500…
arrow_forward
G.
H.
B.
Process Cost Practice Quiz Part 1
The following information is related to the blending department:
1. 1,900 units in beginning WIP, 60X completed as to conversion costs
2. Direct Materials added: 22,000 units
3. Goods completed and transterred total 21,800 units
4. All materials are added at the beginning of the process.
5. Beginning WIP was $7,657
10
6. Cost of DMadded during the month: $77,000
7. Cost of DL added during the month: $14,200
8. Factory overhead applied during the month: $6,880
13 9. Ending WIP inventory is 20% completed as to conversion costs
14
15
12
Required.
16 1 Compute total units to be assigned costs
2. Compute Group 1-3 whole units and equivalent units
18
R.Compute cost per equivalent unit for materials and conversion costs
18
4. Using cost per equivalent unit above, determine (A) cost transferred
20
21
22
out of WIP to next department and (B) cost assigned to ending WIP
VIP- Blending Dept.
23
Units
Units
24
25
26 Beginning
27
28
23 DM
30
31
32 DL
33
34…
arrow_forward
D2L. 7-1 Problem Set: Module Sev X
CengageNOWv2| Online tea X
* Cengage Learning
-2 Project: Company Accour X
+ | x
ow.com/ilm/takeAssignment/takeAssignmentMain.do?invoker3D&takeAssignmentSessionLocator%3D&inprogress%3Dfalse
| 电
eBook
Show Me How
Vertical Analysis
Income statement information for Einsworth Corporation follows:
000
101,400
Sales
Cost of goods sold
Gross profit
Prepare a vertical analysis of the income statement for Einsworth Corporation. If required, round percentage answers to the nearest whole number.
Einsworth Corporation
Vertical Analysis of the Income Statement
Amount Percentage
Sales
0008
Cost of goods sold
101,400
Gross profit
$236,600
Feedback
Check My WNork
Divide each element by sales to determine the vertical analysis percentage.
Check My Work
Previous
Next
3:07 PM
回(ゆ、
4/11/2022
AD
dy
arrow_forward
G
me
Insert
Design Layout References
Management Accounitng-1 Student Activity-Word
6
Mailings
Review
View
Tell me what you want to do...
Sign in
Shan
bri (Body) -11AA Aa E-E-S-3811
Iu・axxx ・ツ・A・ミョ
AA =
Find-
AaBbCcDc AaBbCcDc AaBbC AaBbCcl
Replace
·田
1 Normal No Spac... Heading 1 Heading 2
Select-
Font
Paragraph
2
Styles
GI
Editing
Assignment Problem
Anand Kalaimani Al Harthi SAOG located in Muscat Sultanate of Oman involved in manufacturing of
Drugs and Pharmaceutical Industry from 1981 to till now. The SAOG Company has provided the
following information for the months of September, October, November and December 2023.
Month
Sales
Material
Wages
Postage
Electrical
Other
September
Expense
Expense
10,000
6,000
350
1,200
1,000
5,000
October
12,500
7,500
550
2,400
2,000
6,000
November
13,600
8,200
850
3,600
3,000
5,500
December
19,400
9,000
950
4,800
4,000
3,200
Additional information:
a) Cash Balance on 1/10/2023 is RO X000000
b) Sales 25 per cent is for Cash in the same month. 50 per…
arrow_forward
I need help finishing the rest of the problem.
arrow_forward
How do I fill out the chart?
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
Please answer all parts
Thank you
arrow_forward
Please correctly complete the worksheet and answer those two questions fully!.
arrow_forward
Please correct answer and step by step solution
arrow_forward
Could you help me find the blanks
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- 1. Assign Overhead Costs to Activity Cost Pools 国日 First-Stage Allocation to Activity Cost Pools - Excel Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri -A A 10 Paste BIU - A - Alignment Number Conditional Format as Cell Cells Formatting - Table - Styles - Clipboard Font Styles A1 fx A C E F G 1 == 2 Total costs and distribution of resource consumption across activity cost pools: 3 4 Activity Cost Pools Customer Product Customer Total Cost Orders Development Relations Other Total 6 Production Department: 7 Indirect factory wages $ 400,000 50% 30% 15% 5% 100% Factory equipment depreciation Factory utilities 10 Factory property taxes and insurance 8 150,000 55% 30% 0% 15% 100% 9 120,000 59% 34% 0% 7% 100% 75,000 57% 33% 0% 10% 100% 11 12 General Administrative Department: Administrative wages and salaries Office equipment depreciation 13 275,000 20% 10% 40% 30% 100% 14 40,000 32% 16% 15% 37% 100% 15 Administrative property taxes and insurance 60,000 0% 0% 0% 100%…arrow_forwardctoring Enabled: Chapter 3 Linear Programming.. 6 Saved Help Save & 1 A plumbing repair company has 9 employees and must choose which of 9 jobs to assign each to (each employee is assigned to exactly one job and each job must have someone assigned). a. How many decision variables will the linear programming model include? Number of decision variables b. How many fixed requirement constraint will the linear programming model include? Number of fixed requirement constraintsarrow_forwardTutorial 8 - Managerial Accounting - Word zatimxiz@gmail.com File Mailings View Help O Tell me what you want to do & Share Home Insert Design Layout References Review X Cut P Find - Tahoma 11 -A A Aa - AaBbCcDc AaBbCcDc AaBbC AaBbCcC AaB AaBbccC AqBbCcD E Copy abe Replace Paste в IU -abe X, X* A - aly , I Normal I No Spac. Heading 1 Heading 2 Title Subtitle Subtle Em.. Format Painter A Select - Clipboard Font Paragraph Styles Editing QUESTION 1 E19.5 (Рg. 19-31) E19.5 (LO 2) Gala Company is a manufacturer of laptop computers. Various costs and expenses associated with its operations are as follows. Classify various costs into different cost categories. 1. Property taxes on the factory building. 2. Production superintendents' salaries. 3. Memory boards and chips used in assembling computers. 4. Depreciation on the factory equipment. 5. Salaries for assembly-line quality control inspectors. 6. Sales commissions paid to sell laptop computers. 7. Electrical components used in assembling…arrow_forward
- Activity - Cost According to Cost behavior - ACT 204 - Word Arriane trillanes AT File Home Insert Design Layout References Mailings Review View Help O Tell me what you want to do & Share X Cut • Find - Calibri - 11 A A Aa - AaBbCcDc AaBbCcDc AaBbCcDc AaBbCcDc AaBbCcDc AaBbCcDc AaBbCcl De Copy Paste a. Replace BI U - abe x A - aly I Normal T Body Text T List Para. T No Spac. T Table Pa. T Heading 1 Heading 2 V Format Painter Select - Clipboard Font Paragraph Styles Editing Segregation of Mixed Costs 3. Charity Company wants to analyze the behavior of its selling costs for budgeting purposes. Cost drivers (activity measures) and costs incurred in the first quarter and the first month of the second quarter are as follows: January February March April Selling costs: Sales salaries P 42.500 P 42,500 P 42,500 14,000 32,400 P51,000 16,000 35,600 Commissions 15,000 34,000 17,500 38,000 Shipping costs Advertising 20,000 Full 20,000 Snip 25,000 20,000 Cost drivers: 280,000 28,000 Peso sales…arrow_forwardS Module Three Assignment - ACC X CengageNOWv2 | Online teachir x + gagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogre.. еВook Show Me How Cost Flow Methods The following three identical units of Item K113 are purchased during April: Item Beta Units Cost April 2 Purchase 1 $171 April 15 Purchase 1 175 April 20 Purchase 1 179 3 $525 Total Average cost per unit $175 ($525 + 3 units) Assume that one unit is sold on April 27 for $247. Determine the gross profit for April and ending inventory on April 30 using the (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average cost method. Gross Profit Ending Inventory a. First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted average cost Previous Next> Check My Work 6:38 AM 45°F A D E a O A 40) 11/13/2021arrow_forwardples of Managerial Acco M Question 1- Comprehensive P X + ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Flms.mheducation.com%252Fmghmiddleware%252Fmhepro Comprehensive Problem 5 Saved 1 Part 1 of 6 04:02:14 eBook Print References Required information [The following information applies to the questions displayed below.] Jasper Company, a machine tooling firm, has several plants. One plant, located in Saint Cloud, Minnesota, uses a job order costing system for its batch production processes. The Saint Cloud plant has two departments through which most jobs pass. Plantwide overhead, which includes the plant manager's salary, accounting personnel, cafeteria, and human resources, is budgeted at $250,000. During the past year, actual plantwide overhead was $242,000. Each department's overhead consists primarily of depreciation and other machine-related expenses. Selected budgeted and actual data from the Saint Cloud plant for the past year…arrow_forward
- Accounting excel practice problem - I already solved the first few sub parts to this question - I just need the last sub part answered. I attached a picture of the instructions and a picture of the excel spreadsheet to answer the remaining "formulas".arrow_forwardCould you help me find the activity cost per unitarrow_forwardO Zoom Meeting You are viewing Rinki Maheshwari's screen View Options - Original Sound: Off * View DzL Chapter 6- Marginal costing x O Post Attendee - Zoom M Inbox (2,520) - rinkimahesh x O Dashboard - TimeClockWiz x O Managerial Accounting.pdf x O Dashboard - Instructor + i eastwestcollege.brightspace.com/d21/le/content/7747/viewContent/28312/View Error Prepared by- Aradhana Khera 4. From the following information, find out sales at BEP in units. Variable cost per unit = $15 Sales per unit = $20 Fixed expenses = $54,000 Solution- Contribution per unit = SP per unit - VC per unit= 20-15= $5 BEP IN UNITS = FC/CONTRIBUTION PER UNIT = 54000/5 ull Rinki Maheshwari = 10,800 UNITS 5. Calculate (i) BEP, and (ii) Margin of Safety based on the following information: Sales = $100,000 Total cost = $80,000 Fixed cost = $20,000 Net profit = 80,000 A Download A Print • 24 Leave Unmute Start Video Participants Chat Share Screen Record Reactions ENG 10:16 AM 令中 28 2022-03-04 USarrow_forward
- M (no subject) - redmond.vicki@gn X A Role of Cost in Managerial Accou X D Question 4 - Practice Exam 1 - C x+ Ô https://ezto.mheducation.com/ext/map/index.html?_con3Dcon&external_browser%3D0&launchUrl=https%253A%252F%252Fnewconnect.m Saved H kam 1 G Identify each of the preceding costs as either a product or a period cost. If the cost is a product cost, decide whether it is for direct materials (DM), direct labor (DL), or manufacturing overhead (MOH) and also identify each of the preceding costs as variable or fixed cost. (Select "NA" wherever necessary.) Cost Costs Type of cost Cost head classification Product Factory rent Company advertising Wages paid to assembly workers Depreciation for salespersons' vehicles Screws Period Product Period Product Product Product Utilities for factory Assembly supervisor's salary Sandpaper President's salary Plastic tubing Product Period Product Product Period Paint Sales commissions Factory insurance Depreciation on cutting machines Wages paid to…arrow_forwardE S2 Project Management.pdf DF S3 Product design pdf S3A Learning curves.pdf A 54 Process analysis & job desı X Fosya | C:/Users/alzey/Desktop/Fundamentals%20of%20Production%20Management/S1%20OM%20concepts%20and%20operatio.. O E A) Sesli oku V Çız v 9 Vurgula v O Sil A U.S. MANUFACTURING COMPANY OPERATINGA SUBSIDIARY IN AN LDC (LESS DEVELOPED COUNTRY) SHOWS THE FOLLOWING RESULTS: LDC 20 000 U.S. 100 000 SALES (UNITS) LABOR (HOURS) RAW MATERIALS (CURRENCY) CAPITAL REQUIREMENTS (HOURS) 20 000 15 000 $20 000 FC 20 000 60 000 5 000 A) CALCULATE PARTIAL LABOR PRODUCTIVITY AND CAPITAL PRODUCTIVITY FIGURES FOR THE PARENT AND SU BSIDIARY. DO THE RESULTS SEEM MISLEADING? B) NOW COMPUTE THE MULTIFACTOR PRODUCTIVITY FIGURES FOR LABOR AND CAPITAL TOGETHER. ARE THE RESULTS BETTER? C) FINALLY, CALCULATE RAW MATERIAL PRODUCTIVITY FIGURES (UNIT/S WHERE $1 = FC 10). EXPLAIN WHY THESE FIGURES MIGHT BE GREATER IN THE SUBSIDIARY. aya yazinarrow_forwardivity Based Costing Assignment i nces s://ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https... Al A" ☆ aw 71 N F2 Ly Homework: Activity Based Costin X Required information [The following information applies to the questions displayed below.] # 3 Part Z Part X Totals E Textra produces parts for a machine manufacturer. Parts go through two departments, Molding and Trimming. The company budgets overhead cost of $265,000 in the Molding department and $225,000 in the Trimming department. The company budgets 16,000 machine hours (MH) in Molding and 25,000 direct labor hours (DLH) in Trimming. Actual production information follows. Number of Units 3,000 4,000 F3 Complete this question by entering your answers in the tabs below. R F4 Q Search % Molding Department Hours per Unit 2.0 MH per unit 2.5 MH per unit Required: 1. Compute a departmental overhead rate for the Molding department based on machine hours and a departmental ove rate for the Trimming…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education