How does the budgeting process translate long-term goals into operating objectives? Suppose Framecraft has an Information Processing Division that provides database management services for the professional photographers and artists who buy its frames. The division uses state-of-the-art equipment and employs five information specialists. Each specialist works an average of 160 hours a month. The division’s controller has com piled the following information: Actual Data for Past Year Forecasted Data for This Year November December January February March Client billings (sales) $25,000 $35,000 $25,000 $20,000 $40,000 Selling and administrative expenses 12,000 13,000 12,000 11,000 12,500 Operating supplies 2,500 3,500 2,500 2,500 4,000 Processing overhead 3,200 3,500 3,000 2,500 3,500 Of the client billings, 60 percent are cash sales collected during the month of sale, 30 per cent are collected in the first month following the sale, and 10 percent are collected in the second month following the sale. Operating supplies are paid for in the month of purchase. Selling and administrative expenses and processing overhead are paid in the month following the cost’s incurrence. The division has a bank loan of $12,000 with a 12 percent annual interest rate. Interest is paid monthly, and $2,000 of the loan principal is due on February 28 of next year. Income taxes of $4,550 for this calendar year are due and payable on March 15 of next year. The information specialists earn $8.50 an hour, and all payroll-related employee benefit costs are included in processing overhead. The division anticipates no capital expenditures for the first quarter of the coming year. It expects its cash balance on December 31 of this year to be $13,840. Prepare a monthly cash budget for the Information Processing Division for the three month period ending March 31 of the current year. Comment on whether the ending cash balances are adequate for the division’s cash needs.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
100%

How does the budgeting process translate long-term goals into operating objectives? Suppose Framecraft has an Information Processing Division that provides database management services for the professional photographers and artists who buy its frames. The division uses state-of-the-art equipment and employs five information specialists. Each specialist works an average of 160 hours a month. The division’s controller has com piled the following information: Actual Data for Past Year Forecasted Data for This Year November December January February March Client billings (sales) $25,000 $35,000 $25,000 $20,000 $40,000 Selling and administrative expenses 12,000 13,000 12,000 11,000 12,500 Operating supplies 2,500 3,500 2,500 2,500 4,000 Processing overhead 3,200 3,500 3,000 2,500 3,500 Of the client billings, 60 percent are cash sales collected during the month of sale, 30 per cent are collected in the first month following the sale, and 10 percent are collected in the second month following the sale. Operating supplies are paid for in the month of purchase. Selling and administrative expenses and processing overhead are paid in the month following the cost’s incurrence. The division has a bank loan of $12,000 with a 12 percent annual interest rate. Interest is paid monthly, and $2,000 of the loan principal is due on February 28 of next year. Income taxes of $4,550 for this calendar year are due and payable on March 15 of next year. The information specialists earn $8.50 an hour, and all payroll-related employee benefit costs are included in processing overhead. The division anticipates no capital expenditures for the first quarter of the coming year. It expects its cash balance on December 31 of this year to be $13,840. Prepare a monthly cash budget for the Information Processing Division for the three month period ending March 31 of the current year. Comment on whether the ending cash balances are adequate for the division’s cash needs.

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education