Try the fastest way to create flashcards

Related questions with answers

Lackawanna Community College has three divisions: Liberal Arts, Sciences, and Business Administration. The college's comptroller is trying to decide how to allocate the costs of the Admissions Department, the Registrar's Department, and the Computer Services Department. The comptroller has compiled the following data for the year just ended.

 Department  Annual Cost  Admissions $90,000 Registrar 150,000 Computer Services 320,000\begin{array}{lr} \textbf{ Department } & \textbf{ Annual Cost } \\ \text{ Admissions } & \$ 90,000 \\ \text{ Registrar } & 150,000 \\ \text{ Computer Services } & 320,000 \end{array}

 Budgeted  Budgeted  Planned Courses  Division  Enrollment  Credit Hours  Requiring Computer Work  Liberal Arts 1,00030,00012 Sciences 80028,00024 Business Administration 70022,00024\begin{array}{lccc} & \textbf{ Budgeted } & \textbf{ Budgeted } & \textbf{ Planned Courses } \\ \textbf{ Division } & \textbf{ Enrollment } & \textbf{ Credit Hours } & \textbf{ Requiring Computer Work } \\ \text{ Liberal Arts } & 1,000 & 30,000 & 12 \\ \text{ Sciences } & 800 & 28,000 & 24 \\ \text{ Business Administration } & 700 & 22,000 & 24 \end{array}

1.1. For each department, choose an allocation base and distribute the departmental costs to the college's three divisions. Justify your choice of an allocation base.

2.2. Would you have preferred a different allocation base than those available using the data compiled by the comptroller? Why?

3.3. Build a spreadsheet: Construct an Excel spreadsheet to solve requirement (1)(1) above. Show how the solution will change if the following information changes: the costs incurred by the departments were $120,000\$ 120,000, $160,000\$160,000, and $360,000\$360,000, for Admissions, Registrar, and Computer Services, respectively.

Question

The following data pertain to the Waikiki Sands Hotel for the month of March.

 Flexible Budget March  Actual Results March  (in thousands)*  (in thousands)*  Banquets and Catering $650$658 Restaurants 1,8001,794 Kitchen staff wages (85)(86) Food (690)(690) Paper products (125)(122) Variable overhead (75)(78) Fixed overhead (90)(93)\begin{array}{lcc} & \textbf{ Flexible Budget March } & \textbf{ Actual Results March } \\ & \textbf{ (in thousands)* } & \textbf{ (in thousands)* } \\ \text{ Banquets and Catering } & \$ 650 & \$ 658 \\ \text{ Restaurants } & 1,800 & 1,794 \\ \text{ Kitchen staff wages } & (85) & (86) \\ \text{ Food } & (690) & (690) \\ \text{ Paper products } & (125) & (122) \\ \text{ Variable overhead } & (75) & (78) \\ \text{ Fixed overhead } & (90) & (93) \end{array}

^*Numbers without parentheses denote profit; numbers with parentheses denote expenses.

Prepare a March performance report. The report should have six numerical columns with headings analogous. Your performance report should cover only the Food and Beverage Department and the Kitchen. Draw arrows to show the relationships between the numbers in the report. For the year-to-date columns in your report, use the previous data given. You will need to update those figures using the March data given above.

Solution

Verified
Answered 2 years ago
Answered 2 years ago
Step 1
1 of 8

In this problem, we are asked to prepare for the March performance report of the company.

Create a free account to view solutions

Create a free account to view solutions

Recommended textbook solutions

Managerial Accounting: Creating Value in a Dynamic Business Environment 9th Edition by Ronald W. Hilton

Managerial Accounting: Creating Value in a Dynamic Business Environment

9th EditionISBN: 9780078110917 (6 more)Ronald W. Hilton
859 solutions
Financial Accounting 4th Edition by Don Herrmann, J. David Spiceland, Wayne Thomas

Financial Accounting

4th EditionISBN: 9781259730948Don Herrmann, J. David Spiceland, Wayne Thomas
1,097 solutions
Fundamentals of Financial Management 14th Edition by Eugene F. Brigham, Joel F Houston

Fundamentals of Financial Management

14th EditionISBN: 9781285867977 (1 more)Eugene F. Brigham, Joel F Houston
845 solutions
Century 21 Accounting: General Journal 11th Edition by Claudia Bienias Gilbertson, Debra Gentene, Mark W Lehman

Century 21 Accounting: General Journal

11th EditionISBN: 9781337623124Claudia Bienias Gilbertson, Debra Gentene, Mark W Lehman
1,012 solutions

More related questions

1/4

1/7