ACC522 Managerial Accounting Assignment
Instructions
Complete this assignment in groups of at least two.
Submit this assignment in both electronic and hard copy formats.
Prepare the budgets using MS Excel and submit an electronic copy of the MS Excel template with the report.
All members must contribute equitably to the project.
The due date is 4th December 2017
You are provided with the following information for Al Kalood Co. Ltd. Al Kalood makes a very popular undyed cloth sandal in one style, but in regular and deluxe. The regular sandals have cloth soles and the deluxe sandals have cloth-covered wooden soles. Al Kalood is preparing its budget for June 2015 and has estimated sales based on past experience. Information for the month of June is as follows:
Input prices
Direct materials: cloth $5.25 per meter
Direct materials: wood $7.50 per b.f.
Direct manufacturing labor $15 per direct manufacturing labor-hour
Input quantities per pair of sandals
Regular Deluxe
Direct materials: cloth 1.3 meters 1.5 meters
Direct materials: wood 0 2 board foot (b.f.)
Direct manufacturing labor hours 5 7 hours
Set-up hours per batch 2 hours 3 hours
Inventory information, direct materials
Cloth Wood
Beginning inventory 610 meters 800 b.f.
Target ending inventory 386 meters 295 b.f.
Cost of beginning inventory $3,219 $6,060
Sales and inventory information, finished goods
Regular Deluxe
Expected sales in units 2,000 3,000
Selling price $120 $195
Target ending inventory in units 400 600
Beginning inventory in units 250 650
Beginning inventory in dollars $23,250 $92,625
Al Kalood accounts for inventory (both direct materials and finished goods) using the FIFO cost flow assumption.
All the sandals are made in batches of 50 pairs of sandals. Al Kalood incurs manufacturing overhead costs, marketing and general administration, and shipping costs. Besides materials and labor, manufacturing costs include setup, processing, and inspection costs. Al Kalood ships 40 pairs of sandals per shipment. Al Kalood uses activity-based costing and has classified all overhead costs for the month of June as shown in the following chart:
Cost type Denominator activity Rate
Manufacturing:
Setup Set-up hours $18 per setup-hour
Processing Direct manufacturing labor hrs. $1.80 per DMLH
Inspection Number of pairs of sandals $1.35 per pair
Nonmanufacturing:
Marketing and general administration Sales revenue 8%
Shipping Number of shipments $15 per shipment
Al Kalood’s balance sheet for May 31 is as follows:
Al Kalood’s balance sheet as of May 31
Assets
Cash $9,435
Accounts receivable $324,000
Less: allowance for doubtful debts 16,200 307,800
Inventories
Direct materials 9,279
Finished goods 115,875
Fixed assets $870,000
Less: Accumulated depreciation 136,335 733,665
Total assets $1,176,000
Liabilities and equity
Accounts payable $15,000
Taxes payable 10,800
Interest payable 750
Long-term debt 150,000
Common stock 300,000
Retained earnings 698,904
Total liabilities and equity $1,176,054
The following additional data is provided:
All sales are on account; 60% are collected in the month of the sale, 38% the following month and 2% are written off as bad debts.
All purchases of materials are on account. Al Kalood pays for 80% of purchases in the month of purchase and 20% in the following month.
All other costs are paid in the month incurred, including the declaration and payment of $15,000 cash dividend in June.
Al Kalood is making monthly interest payments of 0.5% on a $150,000 long term loan.
Al Kalood plans to pay the $10,800 of taxes owed as of May 31 in the month of June.
30% of processing, setup, and inspection costs and 10% of marketing and general administration and shipping costs are deprecation.
Al Kalood has a policy of having a cash balance of at least $9,000 at the end of every month. Al Kalood has a line of credit with the local bank.
Required:
Prepare the following budgets for Al Kalood for the month of June:
Sales
Production
Direct material purchases budget
Direct labor budget
Relevant manufacturing overhead budgets
Budgeted income statement
Cash budget with relevant receipts and payment schedules attached as notes
Budgeted balance sheet as of June 30, 2015