D III PUBLIC SECTOR ACCOUNTING (ASP) PROGRAM

FACULTY OF ECONOMICS AND BUSINESS

Campus A, Jalan Kyai Tapa, Grogol, West Jakarta 11440

Tel (021) 5663232 Ext.8361,56969063

MIDDLE SEMESTER EXAM (UTS)

ODD SEMESTER PERIOD 2021/2022

__________________________________________________________________________________

COURSES:MANAGEMENT ACCOUNTING

DAY/DATE:MONDAY/ 25 OCTOBER2021

TIME: 16.00 - 18.30

LECTURER: Dr.,.HERMI, MSi

INSTRUCTIONS:Students who at the time of UTS are proven to have cheated (copy and paste) the answers are exactly the same, then the examinees whose answers are the same will be subject to sanctions in the form of: cancellation of the relevant course (FR score)

================================================== ================================

1. CASH BUDGET

You, as the financial controller ofPT.YAKIN wasasked to make a cash budget with the dataas.following:

.

a.Cash balance per June 1 is IDR 10,000,000

b.Sales in rupiah (Rp):

	April	May	June
cash sales	30,000,000	45,000,000	60,000,000
Credit sales	75,000,000	75,000,000	90,000,000
Total sales	105,000,000	120,000,000	150,000,000

c.Credit sales will be received within 3 months, with the following conditions:

- 70% will be received in the 1st month (on sale), 15% in the 2nd month, and 10% inthe 3rd month.

- Credit sales that will be received in the 3rd month will be subject to a late penaltyof 1.5%of thesales.

- However, only half paid the late fees and business owners felt it was not important to collect the rest because thecosts weregreaterthan the revenues.

- Remaining sales are uncollected sales.

d.Inventory purchases are an average of 70% of total sales per month.Of these purchases, 60% ispaid in the month of purchase.The remaining 40% is paidin the next not.

e.Salary is paid every month in the amount of IDR 20,000,000, including IDR 8,000,000 forbusinessowners.

f.Office rental expense is Rp. 3,500,000 per month.

g.The tax expense for June is IDR 3,000,000

Assumption: Thecompany does not need a minimum cash balance and business owners do nothave access to borrow money in the short term.

REQUESTED:

1.How is depreciation expense treated when making a Cash Budget?

2. Make a cash budgetfor the month of June.

3. What are your recommendations regarding the cash budget that you have made with the above assumptions?

2. VARIANCE ANALYSIS

The standard cost per unit of Syala Company is as follows:

Direct materials 4 yards @$5 ............ $20

Direct labor 1 hour @$15 ..................15

Variable OH 1 hour @$6.......................6

Fixed OH 1 hour @12 ........................12

(Practical capacity of 6,000 direct labor hours)

During the current year the available data are

• 7,000 units of production
• Purchase of direct materials 30,000 yards @$5.2
• The use of direct materials is 19,500 yards
• Direct labor costs $80,000 (consisting of 6,500 direct labor hours)
• Variable overhead cost of $31,000
• Fixed overhead cost of $62,000

REQUESTED:

1. When and why the variance needs to be investigated /
2. Who is responsible for Direct Material variance above tolerance?

3.Calculate and include your calculations for:

1) Material Price Variance and Material Usage Variance

2) Labor Rate Variance and Labor Efficiency Variance

3) Variable OH Spending Variance and Variable OH Efficiency Variance

4) Fixed OH Spending Variance and Fixed OH Volume Variance

3. OPERATING BUDGET

The following is the data for compiling the operating budget for February & March 2020 at PT.ALINDYA

a) During January it can sell 60,000 units of the product and is expected to increase by10% every month.The selling price is IDR 9,000 per unit.

b) Inventories of finished products as of January 31 were 14,000 units.The final finished product inventory is expected to be 25% of last month's unit sales.

c) To produce per unit of finished product, it takes 0.30 liters of Material A at IDR 6,000/liter and 0.20 liters of Material B at IDR 9,000/liter.

d) Inventories of direct materials as of January 31 were 7,000 units of Material A and 5,000 units of Material B. It is expected that the ending inventory of materials is equal to usage to produce 30% of sales units for the month.

e) To produce per unit of product, 0.10 hours of direct work are required in Department I with a wage of IDR 7,000/hour and 0.05 hours of direct work in Department II with a wage of IDR 5,000/hour.

f) Variable overhead costs are assigned to products at a rate of $5,000 per direct labor hour and fixed overhead costs are budgeted for $26,400 per month.

g) Variable selling costs are Rp.300 per unit of sale, while fixed selling costs and fixed administrative costs are budgeted for 10% and 5% of sales, respectively.

REQUESTED:

1. Explain why the Sales Budget is created first before creating other budgets?
2. Explain the importance of budget in profit planning?
3. Prepare an Operating Budget (include your calculations) for February and March 2020 which consists of:

1) Sales Budget

2) Production Budget

3) Direct Materials Purchased Budget

4) Direct Labor Budget

5) Manufacturing Overhead Budget

,

October23, 2021 Jakarta,October 23, 2021