Managerial Accounting

Anonymous
timer Asked: Jan 2nd, 2019
account_balance_wallet $15

Question description

Complete Problems 5-63 and 5-65 in excel format only





we need to refer this videos for sovling the problems in the assignment

*You may submit the assignment answers for Problem 5-63 exclusively in MS Excel format instead of M See YouTube video Week 6, Sample Problem #6 for the answers to #2. Revised Problem 5-65 Fresno Fiber Optics, Inc. manufactures fiber optic cables for the computer and telecommunication industries. At the request of the company VP of marketing, the cost management staff has recently completed a customerprofitability study. The following activity-based costing information was the basis for the analysis. Customer - Related Activities Sales activity Billing and Collection Order taking Special shipping Cost Driver Base Sales visits Invoices Purchase orders Shipments Cost Driver Rate $ 860 160 220 430 Customer - Related Activities Sales activity Billing and Collection Order taking Special shipping Trace Telecom 14 visits 22 invoices 26 orders 12 shipments Caltex Computer 18 visits 26 invoices 28 orders 14 shipments The following additional information has been compiled for Fresno Fiber Optics for two of its customers, Trace Telecom and Caltex Computer, for the most recent year. Sales revenue Cost of goods sold General selling costs General administrative costs Trace Telecom $ 240,000 140,000 42,000 24,000 Caltex Computer $ 226,000 110,000 32,000 18,000 Required: 1. Prepare a customer profitability analysis for Trace Telecom and Caltex Computer. (Hint: Refer to Exhibit 5-13 for guidance). 2. Build a spreadsheet: Construct an Excel spreadsheet to solve requirement (1) above. Show how the solution will change if the following information changes: Trace Telecom's cost of goods sold was $114,000 and Caltex Computer's sales revenue was $206,000. Cost Driver Rate Caltex Computer 26 invoices 14 shipments

Tutor Answer

Chucks574
School: University of Maryland

Thank you so much

1
2
3
4
5
6
7
8
9
10
11

non-value-added
non-value-added
non-value-added
non-value-added
non-value-added
non-value-added
non-value-added
value added
non-value-added
non-value-added
non-value-added

process time storage time
X
X
X
X
X
X
X
X
X

move
time
X
X
X
X
X
X
X

inspection
waiting time
time
X

X
X
X
X

X
X

Revised Problem 5-65
Fresno Fiber Optics, Inc. manufactures fiber optic cables for the computer
and telecommunication industries. At the request of the company VP of
ma...

flag Report DMCA
Review

Anonymous
Good stuff. Would use again.

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors