cost accounting question- please answer in excel with formula

Sigchi4life
Category:
Business & Finance
Price: $10 USD

Question description

Creative Tiles makes tiles in batches of 1,000 tiles each, the standard “unit” in the industry. Each batch consumes $70 in materials and $140 in labor costs. Manufacturing overhead, in total, amounts to $1,500,000 per year and is allocated equally among the batches produced during the year. Creative had no inventories at the beginning of the most recent year. During the most recent year, Creative made 15,000 batches. The firm sold 13,500 batches for an average price of $450 each. Creative incurred variable marketing costs of $50 per batch and fixed marketing costs of $625,000 for the year.

1.  (4 points) Prepare a contribution margin statement for Creative Tiles for the most recent year. In addition, compute the value of the Creative Tiles’ ending inventory under variable costing.

2.  (4 points) Prepare a gross margin statement for Creative Tiles for the most recent year. Also compute the value of the Creative Tiles’ ending inventory under absorption costing.

(4 points) Reconcile the income reported under variable costing and absorption costing. Briefly explain the reason for the difference

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UCLA
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1819 tutors are online

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