PDA

View Full Version : MGT402 Cost & Management Accounting Assignment No.1 Fall Semester 2012



Vuhelper
11-26-2012, 03:27 PM
MGT402 Cost & Management Accounting Assignment No.1 Fall Semester 2012


COST &MANAGEMENT ACCOUNTING (MGT402)
FALL 2012
ASSIGNMENT NO. 1
DUE DATE: 26TH NOVEMBER, 2012
MARKS: 20
TOPIC TO BE TESTED:
Material controlling through Economic order Quantity – EOQ
LEARNING OBJECTIVES:
 To learn about the ways to get control over material by most economical order quantity.
 To learn about the total ordering cost and total carrying cost.
 To learn about the decision making process for choosing suitable proposal on EOQ with the help of
total carrying cost, total ordering cost and total cost basis.
ASSIGNMENT QUESTION
PUNJNAD Textile Industries (PTI) – a privately owned textile spinning unit is engaged in yarn manufacturing
since its incorporation. The unit produces high quality yarn which is sold out immediately like a hot cake. 5
years back, Mr. Entrepreneur - the owner of PTI had signed a contract with a local cotton supplier – Mr.
Supplier for supplying fine quality cotton bails to PTI as per specified requirement for five years at a cost of
Rs. 500 per bail. PTI estimated its requirement of 12,500 cotton bails per year for smooth operations. Both the
owner and the supplier were happy for signing the contract and a feeling of earning the good amount of profit.
Mr. Entrepreneur also estimated Rs. 2,000 as cost on issuing every new order and 10% as carrying and storage
cost associated with the inventory.
Mr. Supplier successfully supplied the cotton bails to PTI for 4 years but in 5th year of the contract, due to
heavy flood, cotton crops could not be reaped at full. But, due to the signed contract with PTI, Mr. Supplier
managed to supply cotton bails to PTI as per the agreed specification and completed the contract period
successfully.
This year, due to bumper cotton crop in the region, Mr. Supplier has desired to renew the cotton supply
contract with the condition to supply 25% extra bails over the previous contract for the next 5 years. Mr.
Entrepreneur as satisfied with the cotton quality supplied earlier is considering this new option and has called
upon his manager costing – Mr. Management Accountant to compare the proposal with the contract just
ended. The manager has advised him to reject the proposal as extra quantity purchased would increase the
carrying and storage cost by 2%.
REQUIREMENT:
Being a student of cost & management accounting you are asked to calculate the following:
1. The most economical order quantity in case of both the proposals (current as well as previous)
2. The total ordering cost which has to be borne by PTI on both the proposals (current as well as
previous)
3. The total Carrying cost which has to be borne by PTI on both the proposals (current as well as
previous)
4. Using the order quantities, total ordering cost and total carrying cost calculated above; calculate the
total cost for both proposals. Also suggests the most suitable proposal for PTI on total cost basis.
IMPORTANT:
24 hours extra / grace period after the due date is usually available to overcome uploading difficulties. This
extra time should only be used to meet the emergencies and above mentioned due dates should always be
treated as final to avoid any inconvenience.
OTHER IMPORTANT INSTRUCTIONS:
DEADLINE:
 Make sure to upload the solution file before the due date on VULMS.
 Any submission made via email after the due date will not be accepted.
FORMATTING GUIDELINES:
 Use the font style “Times New Roman” or “Arial” and font size “12”.
 It is advised to compose your document in MS-Word format.
 You may also compose your assignment in Open Office format.
 Use black and blue font colors only.
RULES FOR MARKING
Please note that your assignment will not be graded or graded as Zero (0), if:
 It is submitted after the due date.
 The file you uploaded does not open or is corrupt.
 It is in any format other than MS-Word or Open Office; e.g. Excel, PowerPoint, PDF etc.
 It is cheated or copied from other students, internet, books, journals etc.

rimaaidas
11-26-2012, 07:23 PM
mgt 402 assignment 1 solution plz

Vuhelper
11-26-2012, 07:35 PM
solution jald he upload ho jay ga dear

Vuhelper
11-26-2012, 09:16 PM
Idea Solution

Here is what I think, since we have a bumper cotton crop, we will not increase any other prices except for the ones asked by the question.

That way:




Per Unit Cost


Annual Required Units


Ordering Cost for One Order


Carrying Costs

Previous Contract


500


12,500


2000


10%

Proposed Contract


500


15,625


2000


12%

Moving on ,
EOQ = [(2xRUxOC)/(UCxCC%)]^1/2

Total Ordering Cost= Required Units/Order Quantity = Number of Orders

= Number of Orders x Cost per Order

Total Carrying Cost = Ordering Quantity/2 = Average Ordering Quantity

=Carry Cost per Unit = Unit Cost x CC%

= Average Ordering Quantity x Carrying Cost Per Unit

Total Cost = Total Ordering Cost x Total Carrying Cost

Per Unit Cost = Total Cost/Order Quantity






Order Quantity


Total Ordering Cost


Total Carry Cost


Total Cost


Per Unit Cost

Previous Contract


1000


25000


25000


50000


50

Proposed Contract


1020.6


31250


30618


61868


60.62

Hence Accountant is right.