Homework Help is Here – Start Your Trial Now!
Business
Accounting
Create a cash payments budget with the following information: I-Frame Inc. manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14 per hour. I-Frame has the following inventory policies: • Ending finished goods inventory should be 40% of next month's sales. • Ending direct materials inventory should be 30% of next month's production. Expected unit sales (frames) for the upcoming months follow: Expected Sales Units March 330

Create a cash payments budget with the following information: I-Frame Inc. manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14 per hour. I-Frame has the following inventory policies: • Ending finished goods inventory should be 40% of next month's sales. • Ending direct materials inventory should be 30% of next month's production. Expected unit sales (frames) for the upcoming months follow: Expected Sales Units March 330

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
icon
Concept explainers
Question
Please do not Give Image format
Create a cash payments budget with the following information: I-Frame Inc. manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14 per hour. I-Frame has the following inventory policies: • Ending finished goods inventory should be 40% of next month's sales. • Ending direct materials inventory should be 30% of next month's production. Expected unit sales (frames) for the upcoming months follow: Expected Sales Units March April May June 330 360 410 510 485 535 July August Variable manufacturing overhead is incurred at a rate of $0.40 per unit produced. Annual fixed manufacturing overhead is estimated to be $8,400 ($700 per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at $750 per month plus $0.50 per unit sold. Of its sales, 80% is in cash and 20% is on credit. Of the credit sales, 50% is collected during the same month of the sale, and 50% is collected during the month following the sale. Of direct materials purchases, 80% is paid for during the month purchased and 20% is paid in the following month. Direct materials purchases for March 1 totaled $2,800. All other operating costs are paid during the month incurred. Monthly fixed manufacturing overhead includes $260 in depreciation. During April, I-Frame plans to pay $2,500 for a piece of equipment. I-Frame had $13,500 cash on hand on April 1. Assume the company can borrow interest-free in increments of $1,000 to maintain a $13,000 minimum ending cash balance. Repayments are made in the following month, assuming sufficient cash is available. (For example, if you need $4,300 at the end of April to meet your desired ending cash balance, you would borrow $5,000 in April, and repay the $5,000 in May). Required: Enter the given data into Excel and prepare the following operating and financial budgets
Transcribed Image Text:Create a cash payments budget with the following information: I-Frame Inc. manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14 per hour. I-Frame has the following inventory policies: • Ending finished goods inventory should be 40% of next month's sales. • Ending direct materials inventory should be 30% of next month's production. Expected unit sales (frames) for the upcoming months follow: Expected Sales Units March April May June 330 360 410 510 485 535 July August Variable manufacturing overhead is incurred at a rate of $0.40 per unit produced. Annual fixed manufacturing overhead is estimated to be $8,400 ($700 per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at $750 per month plus $0.50 per unit sold. Of its sales, 80% is in cash and 20% is on credit. Of the credit sales, 50% is collected during the same month of the sale, and 50% is collected during the month following the sale. Of direct materials purchases, 80% is paid for during the month purchased and 20% is paid in the following month. Direct materials purchases for March 1 totaled $2,800. All other operating costs are paid during the month incurred. Monthly fixed manufacturing overhead includes $260 in depreciation. During April, I-Frame plans to pay $2,500 for a piece of equipment. I-Frame had $13,500 cash on hand on April 1. Assume the company can borrow interest-free in increments of $1,000 to maintain a $13,000 minimum ending cash balance. Repayments are made in the following month, assuming sufficient cash is available. (For example, if you need $4,300 at the end of April to meet your desired ending cash balance, you would borrow $5,000 in April, and repay the $5,000 in May). Required: Enter the given data into Excel and prepare the following operating and financial budgets
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
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.
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
SEE MORE TEXTBOOKS