Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

em #4 (version a) Budgets LoLo Inc. provides exotica dancers. It employs four female dancers. Each dancer works an average of 200 hours a month.

em #4 (version a) Budgets LoLo Inc. provides exotica dancers. It employs four female dancers. Each dancer works an average of 200 hours a month. The company's controller has compiled the following information: Actual Data Forecasted Data November December January February March Billings or $30,000 $35,000 $25,000 $20,000 $30,000 Sales Selling Exp 10,000 11,000 9,000 8,000 10,500 Operating Exp 2,500 3,500 2,500 2,000 3,000 Overhead Exp 3,000 3,500 3,000 2,500 3,000 60% of the client billings are cash sales collected during the month of sale; 30% are collected in the first month following the sale; and 10% are collected in the second month following the sales. Operating supplies are paid for in the month of purchase. Selling expenses and overhead expenses are paid in the month following the cost's incurrence. The company had a bank loan of $12,000 at a 12% annual interest rate. Interest is paid monthly, and $2,000 of the loan principal is due on February 28. Income taxes of $4,500 for the last calendar year are due and payable on March 15. Each dancer earned $8.50 an hour plus tips, and all payroll-related employee benefit costs are included in overhead. Each of them worked 200 hours per month. The company anticipates no capital expenditures for the first quarter of the coming year. It expects its cash balance on December 31 to be $13,000. Required: compute the Monthly Cash Budget for the three month period ended March 21image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Construction Accounting And Financial Management

Authors: Steven J. Peterson

3rd Edition

0132675056, 978-0132675055

More Books

Students also viewed these Accounting questions

Question

1. To understand how to set goals in a communication process

Answered: 1 week ago