Managerial Accouting
ACCT 2102
EXCEL ASSIGNMENT 1
SUMMER SEMESTER 2014
This assignment must be entered into a spreadsheet and emailed to me by WEDNESDAY JULY 2, 2014, midnight.
Please use Excel to solve the textbook Case (pp 152-153). Please use the ABC template as illustrated on page 139 of your textbook in your solution (ALL of the account and product names will have to be changed to the Case question descriptions).
The paper is worth a possible 25 points toward your grade.
All work must be your own and please use formulae whenever you can. A base data sheet will be provided in Folio and the report like that in page 139 should be on a separate tab so that all cells on the separate tab (in the report) should be formulae (except for the textual material). Thus, all additions, subtractions, etc, as well as the inter-worksheet references should all be formulae.
Case.
Coffee Bean, Inc. (CBI), is a processor and distributor of a variety of blends of coffee. The company buys coffee beans from around the world and roasts, blends, and packages them for resale. CBI offers a large variety of different coffees that it sells to gourmet shops in one-pound bags. The major cost of the coffee is raw materials. However, the company's predominantly automated roasting, blending, and packing processes require a substantial amount of manufacturing overhead. The company uses relatively little direct labor. Some of CBI's coffees are very popular and sell in large volumes, while a few of the newer blends sell in very low volumes.
For the coming year, CBI's budget includes estimated manufacturing overhead cost of $3,000,000. CBI assigns manufacturing overhead to products on the basis of direct labor-hours. The expected direct labor cost totals $600,000, which represents 50,000 hours of direct labor time.
The expected costs for direct materials and direct labor for one-pound bags of two of the company's coffee products appear below.
CBI's controller believes that the company's traditional
EXCEL ASSIGNMENT 1
SUMMER SEMESTER 2014
This assignment must be entered into a spreadsheet and emailed to me by WEDNESDAY JULY 2, 2014, midnight.
Please use Excel to solve the textbook Case (pp 152-153). Please use the ABC template as illustrated on page 139 of your textbook in your solution (ALL of the account and product names will have to be changed to the Case question descriptions).
The paper is worth a possible 25 points toward your grade.
All work must be your own and please use formulae whenever you can. A base data sheet will be provided in Folio and the report like that in page 139 should be on a separate tab so that all cells on the separate tab (in the report) should be formulae (except for the textual material). Thus, all additions, subtractions, etc, as well as the inter-worksheet references should all be formulae.
Case.
Coffee Bean, Inc. (CBI), is a processor and distributor of a variety of blends of coffee. The company buys coffee beans from around the world and roasts, blends, and packages them for resale. CBI offers a large variety of different coffees that it sells to gourmet shops in one-pound bags. The major cost of the coffee is raw materials. However, the company's predominantly automated roasting, blending, and packing processes require a substantial amount of manufacturing overhead. The company uses relatively little direct labor. Some of CBI's coffees are very popular and sell in large volumes, while a few of the newer blends sell in very low volumes.
For the coming year, CBI's budget includes estimated manufacturing overhead cost of $3,000,000. CBI assigns manufacturing overhead to products on the basis of direct labor-hours. The expected direct labor cost totals $600,000, which represents 50,000 hours of direct labor time.
The expected costs for direct materials and direct labor for one-pound bags of two of the company's coffee products appear below.
CBI's controller believes that the company's traditional