英语论文网

Please take note that copying the work of others, allowing others to copy your work, and /
or attempting to do any of the above mentioned will result in automatic failure of your
assignment. NO EXCUSES FOR ACTS OF PLAGIARISM WILL BE ENTERTAINED.
You may of course consult textbooks, journals, or any publications for reference
purposes. All sources or materials used should be clearly quoted / referenced.
Before submitting your assignment you should make a copy and submit the original for
assessment. Late submissio本文出自www.51lunwen.org，在代写英语毕业论文与留学生论文方面具有丰富的经验！如果需要原创英语论文，英文论文请联系 QQ：949925041
ns will not be entertained unless there is (are) some legitimate
mitigating factor(s).
QUESTION 1 (14 marks)
Instructions :
(i) Based on the following case study information, build a spreadsheet model using
Excel 97 to answer the accompanying problems.
(ii) The spreadsheet model should include a “Data Input Section” (whereby all raw /
original data from the case should be entered), “Additional Information Section”
(whereby other relevant information for the individual problems should be
entered) and an “Output Section” (whereby the final answers to each problem is
presented).
(iii) Program your spreadsheet to perform all necessary calculations. Do not “hard
code” any amounts, use the addition, subtraction, multiplication, division
operations or any other specialised formulas.
(iv) Print a copy of the spreadsheet with the answers / results to the problems.
(v) Print a copy of the spreadsheet showing the formulas used therein.
Note : Please submit a copy of your CD with your Excel file.
Case study information :
Furnish Well Ltd. manufactures a single product which passes through 2 departments,
Assembly and Finishing.
All work is commenced in Assembly, from which all output is immediately transferred to
Finishing where additional materials are added when processing is 25% complete.
In Finishing, conversion costs are incurred uniformly throughout the process. Overhead is
allocated on the basis of 150% of direct labour cost.
Work in process, 1 Mar (9,000 units, 80% complete), cost of which includes :
Department - Assembly costs $182,250
Department - Finishing direct materials $62,100
Department - Finishing direct labour $22,320
Department - Finishing overheads $?
During the month of Mar, 85,000 units were completed and transferred to finished goods
inventory. Units transferred in from Assembly were charged at $20.50 per unit.
Finishing’s costs in Mar were :
Material本文出自www.51lunwen.org，在代写英语毕业论文与留学生论文方面具有丰富的经验！如果需要原创英语论文，英文论文请联系 QQ：949925041
s added $535,800
Direct labour $260,480
Overheads $?
At the end of the month, 24,000 units were still in process in Finishing. These were
estimated to be 15% complete.
Required :
Prepare the Finishing production cost report for the month of Mar 2007 using the FIFO
method. (14 marks)
QUESTION 2 (11 marks)
Cornerstone Inc. produces 2 products, Capstone and Anchorock. The direct costs of
manufacturing are materials and labour. All other costs are considered as indirect
overhead.
The following information relates to the 2 products for the year 2007 :
Capstone Anchorock
No. of units produced / sold 80,000 40,000
Total direct materials cost $360,000 $120,000
Direct labour cost per hour $12 $12