Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Your team is to prepare a budget report outlining the costs of attending college (full-time) for the next two semesters (30 hours) or three quarters (45 hours). This budget’s focus is solely on attending college; do not include personal items in the team’s budget. Your budget must include tuition, books, supplies, club fees, food, housing, and all costs associated with travel to and from college. This budgeting exercise is similar to the initial phase in activity-based budgeting. Include a list of any assumptions you use in completing the budget. Be prepared to present your budget in class.

Short Answer

Expert verified

The costs for two and three semesters are $69,500 and $104,250, respectively.

Step by step solution

01

Meaning of Budget

A budget is a forecasted statement prepared by the management of the business for the futureand used as an internal tool. Budgeting is the practice of planning for the future. It helps the managers to maintain control over the organization's operations.

02

Preparing a budget

Assumptions, Suppose these are the expenses for two-semester

Tuition fees are $40,000.

Book expenses are $2,000.

Supplies expenses are $5,000.

Club fees are $2,500.

The food cost is $7,000.

The housing cost is $10,000.

Travel expenses are $3,000.

Three-semester expenses are 1.5 times two-semester expenses.

College Cost Budget

Expenses

Two Semester

($)

Three Semester ($)

Tuition fees

40,000

60,000

Book expenses

2,000

3,000

Supplies expenses

5,000

7,500

Club fees

2,500

3,750

The food cost

7,000

10,500

The housing cost

10,000

15,000

Travel expenses

3,000

4,500

Total

69,500

104,250

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

MM Co. predicts sales of \(30,000 for May. MM Co. pays a sales manager a monthly salary of \)3,000 plus a commission of 6% of sales dollars. MM’s production manager recently found a way to reduce the amount of packaging MM uses. As a result, MM’s product will receive better placement on store shelves and thus May sales are predicted to increase by 8%. In addition, MM’s shipping costs are predicted to decrease from 4% of sales to 3% of sales. Compute budgeted sales and budgeted selling expenses for May assuming MM switches to this more sustainable packaging.

Identify at least two potential negative outcomes of budgeting

What is a selling expense budget? What is a capital expenditures budget?

Participatory budgeting can sometimes lead to negative consequences. From the following list of outcomes that can arise from participatory budgeting, identify those with potentially negative consequences.

  1. Budgetary slack will not be available to meet budgeted results.
  2. Employees might understate expense budgets.
  3. Employees might commit unethical or fraudulent acts to meet budgeted results.
  4. Employees set sales targets too high.
  5. Employees always spend budgeted amounts, even if on unnecessary items.
  6. Employees might understate sales budgets and overstate expense budgets.

Question: Aztec Company sells its product for \(180 per unit. Its actual and budgeted sales follow

All sales are on credit. Recent experience shows that 20% of credit sales is collected in the month of the sale, 50% in the month after the sale, 28% in the second month after the sale, and 2% proves to be uncollectible. The product’s purchase price is \)110 per unit. 60% of purchases made in a month is paid in that month and the other 40% is paid in the next month. The company has a policy to maintain an ending monthly inventory of 20% of the next month’s unit sales plus a safety stock of 100 units. The April 30 and May 31 actual inventory levels are consistent with this policy. Selling and administrative expenses for the year are \(1,320,000 and are paid evenly throughout the year in cash. The company’s minimum cash balance at month-end is \)100,000. This minimum is maintained, if necessary, by borrowing cash from the bank. If the balance exceeds \(100,000, the company repays as much of the loan as it can without going below the minimum. This type of loan carries an annual 12% interest rate. On May 31, the loan balance is \)25,000, and the company’s cash balance is \(100,000. (Round amounts to the nearest dollar.)

Required

1. Prepare a schedule that shows the computation of cash collections of its credit sales (accounts receivable) in each of the months of June and July.

2. Prepare a schedule that shows the computation of budgeted ending inventories (in units) for April, May, June, and July.

3. Prepare the merchandise purchases budget for May, June, and July. Report calculations in units and then show the dollar amount of purchases for each month.

4. Prepare a schedule showing the computation of cash payments for product purchases for June and July.

5. Prepare a cash budget for June and July, including any loan activity and interest expense. Compute the loan balance at the end of each month.

Analysis Component

6. Refer to your answer to part 5. The cash budget indicates the company will need to borrow more than \)18,000 in June. Suggest some reasons that knowing this information in May would be helpful to management.

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free