Question

In: Accounting

URGENT!! 5.From the following, prepare a cost sheet and the price to be quoted. 1.1.2018 31.12.2018...

URGENT!!
5.From the following, prepare a cost sheet and the price to be quoted.


1.1.2018 31.12.2018


Raw materials 20,000 32,000


Work-in-progress 26,500 14,000


Finished Goods 16,000 18,000


Purchases of raw materials 90,000 Carriage inwards 2,000 Direct wages 40,000


Direct expenses 15,000 Works overheads 22,500 Administration overheads 10,000


Selling and distribution overheads 14,000 Sales 2,20,000.


The Company wants to Quote the price for the order received from the customer, where the


material required is 4000 and labour 3000. Expected profit 25% margin on sales.


Solutions

Expert Solution

Statement of Cost sheet on 31.12.2018

Particulars Amount
Opening stock of Raw material 20000
Add:Purchase of Raw materials(inculding carrige inward) 92000
Less:Closing stock of raw materials -32000
Raw material consumed 80000
Add:Direct wages 40000
Add:Direct Expenses 15000
Prime costs 135000
Add: Works overheads 22500
Gross factory costs 157500
Add:opening work in progress 26500
Less:ending work in progress 14000
Net factory costs 170000
Add:Administration overheads 10000
Cost of Production 180000
Add:Opening stock of finish goods 16000
Less:Ending stock of finish goods 18000
Cost of goods sold 178000
Add:selling & distribution overheads 14000
Cost of Sales 192000
Profits (balancing figure) 28000
Sales 220000

Statement showing the price to be charged for order received from customer

Particulars Amounts
Material Required 4000
Labour Required 3000
Total costs 7000
Add:Profits 25%on sales or 1/4 on sales,1/3 on costs (7000/3) 2333
Selling price or quoted price for order 9333

Related Solutions

What is the quoted price of a bond with 5 years to maturity, a coupon rate...
What is the quoted price of a bond with 5 years to maturity, a coupon rate of 8%, and a YTM of 7.5%? Coupons are paid semi-annually.
What is the quoted price of a bond with 5 years to maturity, a coupon rate...
What is the quoted price of a bond with 5 years to maturity, a coupon rate of 8%, and a YTM of 7.5%?
(Preparing a balance sheet) Prepare a balance sheet from the information in the following table. Hint:...
(Preparing a balance sheet) Prepare a balance sheet from the information in the following table. Hint: Use the accumulated depreciation account as a negative value. Retained earnings won't be needed for the question. Cash $50,132 Accounts receivable $42,602 Accounts payable $23,319 Short-term notes payable $10,819 Inventories $40,844 Gross fixed assets $1,280,667 Other current assets $5,172 Long-term debt $200,715 Common stock $490,856 Other assets $15,160 Accumulated depreciation $311,215 Retained earnings ? What is the firm's debt ratio: _______% (Round to one...
1)Prepare an ending 2014 Income Statement and Balance Sheet from the following information: Sales $800,000; Cost...
1)Prepare an ending 2014 Income Statement and Balance Sheet from the following information: Sales $800,000; Cost of Goods Sold $300,000; Accounts Receivables $20,000; Bonds Outstanding $160,000; Accounts Payable $20,000; Advertising Expense $1,000; Administrative Expenses $35,000; Interest Expense $24,000; Depreciation Expense $40,000; Dividends Paid $137,000; Rent Expense $5,000; Accruals $20,000; Common Stock $100,000; Retained Earnings $245,000 (Beginning 0f 2014); Cash $20,000; Inventory $45,000; Net Fixed Assets $600,000 (Beginning of 2014). (Assume a 40% Tax Rate)
URGENT 7.(a)From the following data prepare a flexible budget for production of 40000 units clearly showing...
URGENT 7.(a)From the following data prepare a flexible budget for production of 40000 units clearly showing variable cost, fixed cost, and total cost. Budgeted capacity output is 1 lakh units and the budgeted cost per unit is given below: (7.5+7.5=15 marks) Direct Material Rs 95/unit. Direct Labour Rs 50/unit. Production overhead (75% variable) Rs 40/unit. Administration overhead (100% fixed) Rs 5/unit. Selling overhead (20% fixed) Rs10/unit. (b) Prepare a Production Budget for the six months period ending on 30th June,2017...
From the following balance sheet and additional information given, prepare cash flow statement. Balance Sheet as...
From the following balance sheet and additional information given, prepare cash flow statement. Balance Sheet as on March 31, 2005 and 2006 Particulars 2005 Rs. 2006 Rs. Particulars 2005 Rs. 2006 Rs. Share Capital 9,00,000 9,00,000 Fixed Assets 8,00,000 6,40,000 General Reserve 6,00,000 6,20,000 Investments 1,00,000 1,20,000 Profit & loss a/c 1,12,000 1,36,000 Stock 4,80,000 4,20,000 Creditors 3,36,000 2,68,000 Debtors 4,20,000 9,10,000 Provision for tax 1,50,000 20,000 Bank 2,98,000 3,94,000 Mortgage loan - 5,40,000 20,98,000 24,84,000 20,98,000 24,84,000 Additional Information:...
The currently quoted price (3 years before maturity date) of a 5-year bond with a nominal...
The currently quoted price (3 years before maturity date) of a 5-year bond with a nominal of 1,000,000 PLN, interest 4% pa, coupons paid each 4M, is PLN 900,000. Calculate PVB and determine whether investor should buy this bond (or not) for the quoted price, if expected YTM during maturity period is 8% pa?
The currently quoted price (3 years before maturity date) of a 5-year bond with a nominal...
The currently quoted price (3 years before maturity date) of a 5-year bond with a nominal of 1,000,000 PLN, interest 4% pa, coupons paid each 4M, is PLN 900,000. Calculate PVB and determine whether investor should buy this bond (or not) for the quoted price, if expected YTM during maturity period is 8% pa?
A treasury note is quoted with a bid price of 102.24 and an asking price of...
A treasury note is quoted with a bid price of 102.24 and an asking price of 102.28. The spread on the treasury note is: $0.125 $1.25 $0.04 $0.40
(Preparing a balance sheet​) Prepare a balance sheet from the information in the popup​ window, ....
(Preparing a balance sheet​) Prepare a balance sheet from the information in the popup​ window, . What are the networking capital and debt​ ratio? Complete the part of the balance sheet below.  ​(Round to the nearest dollar. NOTE​: Input the Accumulated depreciation account as a negative​ value.) Balance Sheet ASSETS Cash $ Total current assets $ $ Net fixed assets $ Total assets $ Choose from any list or enter any number in the input fields and then click Check...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT