22567 Quiz -1 Spring 2022- Rossanne David

xlsx

School

University of Technology Sydney *

*We aren’t endorsed by this school

Course

22016

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

36

Uploaded by rossanne

Report
Question 1: Please place your answers in Canvas in Q1 to Q8 Calculating a Labour Charge Rate per $ Base Rate Labour On Costs Superannuation Payroll Tax Workers Compensation Insurance Labour Charge Rate per $1 Leave Calculations Annual Leave Public Holidays Sick Leave Total Leave Days in Year Days worked OUR Legal Practice Staff Gross ANNUAL Salaries of Staff are as follows: Receptioist / Secretary Office Manager Accountants Total Labour Cost Part 2: Chargeable Hours - Budge Weekly Working Hours - Normal Number of Weeks per year Revenue Generation - QUANTITY - What ar
Total Annual Hours Less Hours Not Worked Annual Leave Public Holidays Sick Leave Annual Hours Available Total Billable Hours No of Accountants Total EXPECTED Chargeable Hours per year It is expected that each accountant generate at least $$$ Part 3 Operating Co Activity / Resource Utilisation Office & Computer Equip. at cost (useful lfe = 3 years) Non Billable Hours = (% Hours not billed) Bookkeeping Expenses (50 weeks p.a. 8 hours per week) Bank Charges (per month) Cleaning (Only Open 50 weeks per Year) Computer support (Only Open 50 weeks per Year) Insurances (yearly * no. policies) Light & Power (monthly)
Total Other Overheads Before Labour Labour Costs - To be Added Admin Labour Costs - Recxeptionists + Office Managers Professional Accountant Salaries TOTAL Costs Part 4 COST RECOVERY - PROFIT PLAN Charge out rate to earn Break Even = Total Revenue = Total Cost Profit Total Costs Forecast Revenue Forecast HOURS HOURLY CHARGE to earn ZERO Profit Part 6 What should be the charge-out rate Per Hour for the busin Charge out rate to earn profit $350,000 Rent (per sq mtr * per annum) - Current Office space 190 sq mtrs Stationery (per month) Telecommunications - Postage (per month) Other Expenses including Office Supplies etc. (per month)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Profit Total Costs Forecast Revenue Forecast HOURS HOURLY CHARGE to earn $350,000 Part 7: If the firm wants to make a profit margin of 25% of total revenue Forecast Revenue Total Costs Profit 25% Forecast HOURS HOURLY CHARGE-Out Rate Part 8: If the firm wants to make a profit using a markup of 35% on total co Forecast Revenue Total Costs Profit Forecast HOURS HOURLY CHARGE-Out Rate
$1 of Labour Cost Charge Rate per $ $1.0000 $0.0950 9.50% $0.0485 4.85% $0.0450 4.50% $1.1885 Q1 284 weeks 142 weeks 71 week 49 365.25 316.25 ff Labour Cost Details Base Salary 2 $185,000 $219,873 1 $115,000 $136,678 3 $405,000 $481,343 $705,000 $837,893 Q2 et 35.0 52.18 Gross Salary + On Costs re we selling?? TIME:
1,826.25 140 70 35 245 1,581.25 28% 442.75 1,138.50 3 3,415.50 Q3 $$$ Per unit of chargeable time. ost Budget Cost per Unit Calculation $40 per hour $16,000 $95 / month $1,140 $145 / per week $7,250 $120 / per week $6,000 $12,800 $16,800 / per annum $16,800 $790 / month $9,480 Total Cost (p.a) per annum $38,400 ÷ 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$248 / sqr mtr p.a $1 $160 / Month $1,920 $875 / month $10,500 $1,550 / month $18,600 $100,491 $356,550 $481,343 $938,383 Q4 NNING $0 $938,383 $938,383 3,415.50 $274.74 Q5 ness to make a profit of $350,000?
$350,000 $938,383 $1,288,383 ` 3,415.50 $377.22 Q6 e, calculate the charge-out rate Per Hour? $1,172,979 $938,383 $234,596 3,416 $343.43 Q7 osts, calculate the charge-out rate Per Hour. $1,251,178 75 $938,383 $312,794 3,416 $366.32 Q8
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Place all answers to the questions Q1: Calculate Total Labour Charge Rate per $1. Q3: How many CHARGEABLE hours are expected to be available for the comin Q4: Calculate TOTAL COSTS of operating the practice including Operating cos Q5: Using the total cost information, calculate the BREAK EVEN CHARG Q6: What should be the charge-out rate Per Hour for the business to make a Q2 What is the TOTAL LABOUR COST for the practice including the on-costs o Compensation Insurance, and Payroll Tax. Q7: If the firm wants to make a profit margin of 25% of total revenue, c rate Per Hour? Q8: If the firm wants to make a profit using a markup of 35% on total costs, c Hour. The partnership expects to incur operating expenses, as shown adjacent, for the next financial year.
in CANVAS - Q1 to Q8 ng year? sts and Labour Costs. GE OUT RATE per hour. profit of $350,000? of Superannuation, Workers calculate the charge-out calculate the charge-out rate Per
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Question 2: Please place your answers in Canvas - Q9 to Q16 Sales Revenue Less COGS Gross Profit Less Marketing & Admin Exp Profit Before tax Less tax Profit after Tax Variable Costs Fixed Costs Production Costs 300,000 640000 Marketing & Administartion 18000 522000 Totals $318,000.00 $1,162,000.00 no. unit SOLUTIONS SECTION DATA SECTIO Sales 1,680,000 Sales Units Variable Costs 480,000 Unit Sales Price Contribution Margin 1,200,000 Variable Costs Production Fixed Costs 1,162,000 Marketing & Administartion Profit before taxes 38,000 Total UNIT Variable Costs Less Tax at 30% 11,400 Fixed Costs Profit after Taxes 26,600 Production Marketing & Administartion Total Fixed Costs Tax rate CM/Unit CM Ratio Sales $28.00 100.00% Less Variable Costs $8.00 350%
Contribution Margin $20.00 -250.00% Q9 Q10 Solutions Data Sales Sales Quantity Less Variable Costs Sales price per unit Contribution Margin Unit Variable Cost Less Fixed Costs Total Fixed Costs Profit Before Tax Less Tax Tax rate Profit after tax Solutions Data Sales $2,394 Sales Quantity Less Variable Costs Sales price per unit Contribution Margin Unit Variable Cost Less Fixed Costs Total Fixed Costs Profit Before Tax Less Tax Tax rate Profit after tax Solutions Data Sales $0 Sales Quantity Less Variable Costs 945,000 Sales price per unit Contribution Margin -945,000 Unit Variable Cost Less Fixed Costs 1,240,000 Total Fixed Costs
Profit Before Tax -2,185,000 Less Tax -655,500 Tax rate Profit after tax -$1,529,500 Proof #DIV/0!
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Total Cost 940000 5 540000 3 $1,480,000.00 $8.00 60,000 ON 60,000 $28.00 $8.00 $1,162,000 30% Unit Variable Costs
Q11 Place all a $28.00 Q9: Calculate the Contribu $8.00 Q10: $1,162,000 Q11: What is the breakeven Q12: Q13: Q14: Q15: Q16: Q12 $30.00 $53.00 $1,162,000 42,000 Q13 $22.50 $1,240,000 Calculate the Contribu Calculate the number of sales revenue. Calculate the selling p volume of 42,000 unit At a sales quantity of 6 necessary to earn an a The Company has rece costs of $20,000 are to market sales are expe on the overseas order The company has bee covered by the compa price of $10.00 per un this order?
30%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
answers to the questions in CANVAS - Q25 to Q32 ution Margin per unit $20.00 ### n point in Units for the company? ution Margin Ratio. (4 decimal points) of units that must be sold at a price of $30.00 to earn a net profit after tax equal to 9% price per unit that will generate an after-tax return of 15% of total costs based on a sales ts. 60,000 units and using a selling price of $29.00, what is the reduction in variable costs after-tax profit equal to 13% of Sales Revenue? eived an order from an overseas buyer to purchase 20,000 units of product. Additional fixed o be incurred for the overseas order, being an annual payment to the overseas agent. Domestic ected to be 30,000 units at an average selling price of $32.00. What selling price should be charged r to earn a net profit after tax equal to 9% of total revenue? en approached by an interstate competitor who operates in a market not presently any. The competitor wants to trial the product and has offered to buy 1,000 units of product at a nit. What will be the impact on existing pre-tax profits (losses) associated with the acceptance of
Question 3: Please place your answers in Canvas in Q17 to Q24 PRODUCTION BUDGET July August September Sales 96,000 105,000 112,000 Add Closing Inventory 14,400 15,750 16,800 110,400 120,750 128,800 Less Opening Inventory 14,400 14,400 15,750 Production 96,000 106,350 113,050 MATERIALS USAGE BUDGET Cotton July August September Production Requirements 240,000 265,875 282,625 Add: Closing Inventory 26,588 28,263 Total Requirements 266,588 294,138 Less Opening Inventory 4,300 26,588 COTTON - Purchases 262,288 267,550 Plastic July August September Production Requirements 115,200 127,620 135,660 Add: Closing Inventory 12,762 13,566 Total Requirements 127,962 141,186 Less Opening Inventory 2,320 12,762 PLASTIC - Purchases 125,642 128,424 MATERIALS PURCHASES BUDGET July August September Cotton $721,291 $735,763 Plastic $332,951 $340,324 Total $ Cost of Purchases $1,054,242 $1,076,086
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
LABOUR BUDGET July August September Production 96,000 106,350 Hours per unit 1.5 Total Direct labour Hours 144,000 159,525 Hourly rate $18.60 Projected Labour Cost $2,678,400 $2,967,165 $5,645,565 OVERHEAD BUDGET July August Direct Labour Hours Worked 2,678,400 2,967,165 Overhead Rate per Direct Laboutr Hour $ 12.50 Total Overhead Applied $33,480,000 $37,089,563 $70,569,563 Unit Cost Budget Direct Material Cotton $6.88 Direct Material Plastic $3.18 Total Materials $10.06 Direct Labour $27.90 Applied Overhead $348.75 Total Cost per Widget $386.7050 COST OF GOODS SOLD Budget July August Opening Inventory $5,568,552 $5,568,552 Production $37,123,680 $41,126,077 Cost of Goods Available $42,692,232 $46,694,629 Closing Inventory $5,568,552 $6,090,604 COST OF GOODS SOLD $37,123,680 $40,604,025 $77,727,705
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
GROSS PROFIT July August Sales $8,496,000 $9,292,500 $88.50 Less COGS $37,123,680 $40,604,025 Gross Profit -$28,627,680 -$31,311,525 -$59,939,205
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
October 118,000 17,700 15% 135,700 2.5 10% 1.2 10% unit cost $2.75 $2.65
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Place all answers to the qu Q17: How many Ridgets are to be produced in Augus Q18: What is the closing Inventory of Ridgets in Augus Q19: What is the quantity of Cotton to be purchased i Q20: What is the total cost of Purchases for both Cott Q21: What is the total cost of Labour for July + August Q22: What is the total cost of Overhead for July + Augu Q23: What is the Unit cost to manufacture 1 Ridget? Q24: What is the total Gross Profit for July + August? 0.125
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
uestions in CANVAS - Q9 to Q16 st? st? in July? tton & Plastic in August? t? ust?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Question 4: Please place your answers in Canvas in Q25 to Q32 Sales and CASH Collection of Sales Re May June July Sales Units 10,000 9,000 9,500 Sales Price $110,000 $99,000 $104,500 Sales Revenue $1,100,000,000 $891,000,000 $992,750,000 Less: Cash Sales $110,000,000 $89,100,000 $99,275,000 Credit Sales $990,000,000 $801,900,000 $893,475,000 Collection of Account Sales 80% I month after sale $792,000,000 $641,520,000 15% 2 month after sale $148,500,000 Total Collections $1,683,495,000 Total Cash Sales and Account Collection $1,782,770,000 Inventory May June July UNITS Sold 10,000 9,000 9,500 Add Closing Inventory 4500 4750 5500 Total Requirements 14,500 13,750 15,000 Less Opening Inventory 4500 4750 Units Purchased 14,500 9,250 10,250 Unit Cost of Purchases Payments to Suppliers July Purchases $ $893,475,000 Less Payments Current Month (20%) $178,695,000 1 Month (80%) $641,520,000 Total payments to suppliers $820,215,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Selling & Admin Expenses Depreciation Cash Selling and Admin Expense Incurred Paid 1 month after Cash Budget - July - August - Septem July Cash Received Less Cash Payments Cash Paid to Suppliers Cash Paid for Selling Admin Expenses Capital Expenditure Interest Payment Net Change in Cash Add Cash at Start of Month =CASH BALANCE at End of Month Statement of Financial Performance - July - Aug July Sales revenue Less Cost of Goods Sold GROSS PROFIT Less Expenses Bad Debts Expense Selling & Admin Expense Interest Expense Total Expenses
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Net Profit
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
evenue August September October 11,000 12,000 10,000 $121,000 $132,000 $110,000 $1,331,000,000 $1,584,000,000 $1,100,000,000 $133,100,000 $158,400,000 $110,000,000 10% $1,197,900,000 $1,425,600,000 $990,000,000 $714,780,000 $958,320,000 $1,140,480,000 80% $120,285,000 $134,021,250 $179,685,000 15% $2,032,965,000 $2,517,941,250 $2,166,065,000 $2,676,341,250 $110,000,000 August September 11,000 12,000 6000 0 50% 17,000 12,000 5500 6000 11,500 6,000 August September $1,197,900,000 $1,425,600,000 $239,580,000 $285,120,000 $714,780,000 $958,320,000 $954,360,000 $1,243,440,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
mber August September gust - September August September
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Place all answers to the questions in CAN Q25: What is the budgeted sales revenue for August? Q26: What is the expected Cash sales for September? Q27: How many units are budgeted to be purchased in August? Q29: What is the expected cash payment to suppliers in August? Q31: How much is the expected Gross Profit for the month of July? Q32: How much is the expected Net Profit for the month of September? Q33: Please submit the Excel spreadsheet with your worki July August September Sales Revenue 992,750,000 1,331,000,000 1,584,000,000 Less Cost of Sales Gross Profit Less Variable Expenses Bad Debts Variable Selling Expense Variable Admin Expense Total Variable Expense CONTRIBUTION MARGIN Less Fixed Expenses Fixed Selling Expense Fixed Admin Expense Depreciation Total Fixed Expense Net Income Q28: What is the Unit cost of Inventory on 30 th June? Q30: Wat is the expected CASH BALANCE as at 31 st August?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
NVAS - Q17 to Q25 $1,331,000,000 $1,425,600,000 11,500 $0.00 $954,360,000 $0 $0 $0 ings for each of the questions.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help