Angelini’s has been in business since January of the current year. The company buys fresh pasta and resells it to large supermarket chains. The following information pertains to Angelini’s first four months of operations:   Purchases   Sales   January $50,000   $80,000 February 40,000   60,000 March 55,000   90,000 April 25,000   40,000 Angelini’s expects to open several new sales territories in May. In anticipation of increased volume, management forecasts May sales at $100,000. To meet this

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter21: Cash Budgeting (cashbud)
Section: Chapter Questions
Problem 1R: On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is...
icon
Related questions
icon
Concept explainers
Question

Angelini’s has been in business since January of the current year. The company buys fresh pasta and resells it to large supermarket chains. The following information pertains to Angelini’s first four months of operations:

 

Purchases

 

Sales

 

January

$50,000  

$80,000

February

40,000

 

60,000

March

55,000

 

90,000

April

25,000

 

40,000

Angelini’s expects to open several new sales territories in May. In anticipation of increased volume, management forecasts May sales at $100,000. To meet this demand, purchases in May are budgeted at $60,000. The company maintains a gross profit margin of approximately 40 percent.

All of Angelini’s sales are on account. Due to strict credit policies, the company has no bad debt expense. The following collection performance is anticipated for the remainder of the year:

Percent collected in month of sale

40%

Percent collected in month following sale

50

Percent collected in the second month following sale

10

Angelini’s normally pays for 75 percent of its purchases in the month that the purchases are made. The remaining amount is paid in the following month. The company's fixed selling and administrative expenses average $10,000 per month. Of this amount, $3,000 is depreciation expense. Variable selling and administrative expenses are budgeted at 5 percent of sales. The company pays all of its selling and administrative expenses in the month that they are incurred.

 

Angelini’s debt service is $4,000 per month. Of this amount, approximately $3,000 represents interest expense, and $1,000 is payment on the principal. The company's tax rate is approximately 25 percent. Quarterly tax payments are made at the end of March, June, September, and December.

Instructions:

  1. Prepare Angelini’s budgeted income statement for May.
  2. Prepare Angelini’s cash budget for May. Assume that the company's cash balance on May 1 is $30,000.
  3. What are the primary benefits that Angelini’s will gain from preparing and using a budget?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 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
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning