Elliott Industries, a wholesale company, is considering whether to open a new distribution center.  The center would open January 1, 2021.  To make the decision, the planning committee requires a master budget for the center’s first quarter of operation (January, February, and March of 2022).    Required You are to construct the first quarter master budget based on the following expectations: January sales are estimated to be $400,000 of which $100,000 will be cash sales and $300,000 will be on credit. The company expects sales to grow 10% per month for the first few months of operation.  Prepare a sales budget for the first quarter.   The company expects to collect 100% of accounts receivable in the month following the sale. Prepare a schedule of expected cash receipts for the first quarter.   Cost of goods sold will be 60% of sales. Company policy is to budget an ending inventory balance equal to 25% of the next month’s projected cost of goods sold.  Assume Elliott expects April cost of goods sold to be $314,000.  Prepare an inventory purchases budget.   All inventory purchases are on account. The company pays 70% of accounts payable in the month of purchase.  It pays the remaining 30% in the following month.  Prepare a schedule of expected cash payments for inventory purchases.   Budgeted monthly selling and administrative expenses are: Salary Expense (Fixed) $24,000 Sales Commissions 5% of Sales Supplies Expense 2% of Sales Utilities (Fixed) $ 1,400 Depreciation on Center Equipment (Fixed)* $    750 Rent (Fixed) $ 3,600 Miscellaneous (Fixed) $    900          *The capital expenditures budget shows that Elliott must purchase $100,000 of equipment on January 1 to establish the new center.  The equipment supplier allows a thirty-day trial period.  Elliott will pay for the equipment on January 31.  The equipment is expected to have a 10-year useful life and a $10,000 salvage value.  Prepare a selling and administrative expense budget.   Sales commissions and utilities are paid in the month after the month in which they are incurred. All other expenses are paid in the month they are incurred.  Prepare a schedule of cash payments for selling and administrative expenses.   Use the information developed in requirements g and h to determine the amount of sales commissions payable, utilities payable, and accumulated depreciation on the March 31 pro forma balance sheet and the amount of selling and administrative expense on the first quarter pro forma income statement.   Using a line of credit, Elliott borrows and repays principal in increments of $1,000 on the last day of the month as needed. It pays interest of 1 percent per month in cash on the last day of the month.  Company policy is to maintain an ending cash balance of at least $12,000.  Use this information and the schedules prepared in requirements b, e, and h to prepare a cash budget.

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

Elliott Industries, a wholesale company, is considering whether to open a new distribution center.  The center would open January 1, 2021.  To make the decision, the planning committee requires a master budget for the center’s first quarter of operation (January, February, and March of 2022). 

 

Required

You are to construct the first quarter master budget based on the following expectations:

  1. January sales are estimated to be $400,000 of which $100,000 will be cash sales and $300,000 will be on credit. The company expects sales to grow 10% per month for the first few months of operation.  Prepare a sales budget for the first quarter.

 

  1. The company expects to collect 100% of accounts receivable in the month following the sale. Prepare a schedule of expected cash receipts for the first quarter.

 

  1. Cost of goods sold will be 60% of sales. Company policy is to budget an ending inventory balance equal to 25% of the next month’s projected cost of goods sold.  Assume Elliott expects April cost of goods sold to be $314,000.  Prepare an inventory purchases budget.

 

  1. All inventory purchases are on account. The company pays 70% of accounts payable in the month of purchase.  It pays the remaining 30% in the following month.  Prepare a schedule of expected cash payments for inventory purchases.

 

  1. Budgeted monthly selling and administrative expenses are:

Salary Expense (Fixed)

$24,000

Sales Commissions

5% of Sales

Supplies Expense

2% of Sales

Utilities (Fixed)

$ 1,400

Depreciation on Center Equipment (Fixed)*

$    750

Rent (Fixed)

$ 3,600

Miscellaneous (Fixed)

$    900

         *The capital expenditures budget shows that Elliott must purchase $100,000 of equipment on January 1 to establish the new center.  The equipment supplier allows a thirty-day trial period.  Elliott will pay for the equipment on January 31.  The equipment is expected to have a 10-year useful life and a $10,000 salvage value.  Prepare a selling and administrative expense budget.

 

  1. Sales commissions and utilities are paid in the month after the month in which they are incurred. All other expenses are paid in the month they are incurred.  Prepare a schedule of cash payments for selling and administrative expenses.

 

  1. Use the information developed in requirements g and h to determine the amount of sales commissions payable, utilities payable, and accumulated depreciation on the March 31 pro forma balance sheet and the amount of selling and administrative expense on the first quarter pro forma income statement.

 

  1. Using a line of credit, Elliott borrows and repays principal in increments of $1,000 on the last day of the month as needed. It pays interest of 1 percent per month in cash on the last day of the month.  Company policy is to maintain an ending cash balance of at least $12,000.  Use this information and the schedules prepared in requirements b, e, and h to prepare a cash budget.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

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