budgeted sales as indicated in the following table. The company expects a 10 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterMB: Model-building Problems
Section: Chapter Questions
Problem 22M
icon
Related questions
Question
Parliament Company, which expects to start operations on January 1, year 2, will sell digital cameras in shopping malls. Parliament has
budgeted sales as indicated in the following table. The company expects a 10 percent increase in sales per month for February and
March. The ratio of cash sales to sales on account will remain stable from January through March.
Required
a. Complete the sales budget by filling in the missing amounts.
Note: Use the cells from the given information to complete this question.
February
Sales
Cash sales
Sales on account
Total budgeted sales
January
1
b. Determine the amount of sales revenue Parliament will report on its first quarter pro forma income statement.
Note: Use the cells from the given information to complete this question.
Sales revenue
$50,000
120,000
$170,000
$170,000
March
$0
0
$0
$0
10%
Transcribed Image Text:Parliament Company, which expects to start operations on January 1, year 2, will sell digital cameras in shopping malls. Parliament has budgeted sales as indicated in the following table. The company expects a 10 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. Required a. Complete the sales budget by filling in the missing amounts. Note: Use the cells from the given information to complete this question. February Sales Cash sales Sales on account Total budgeted sales January 1 b. Determine the amount of sales revenue Parliament will report on its first quarter pro forma income statement. Note: Use the cells from the given information to complete this question. Sales revenue $50,000 120,000 $170,000 $170,000 March $0 0 $0 $0 10%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
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
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College