Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can I see the work on how to get the numbers with formulas and everything. Sales revenue in February 4,050,000 Sales Revenue in March 4,150,000

Can I see the work on how to get the numbers with formulas and everything.

image text in transcribed
Sales revenue in February 4,050,000 Sales Revenue in March 4,150,000 Purchases in March 1,350,000 CASH BUDGET April May June Total Units sold 180000 200000 210000 Collected from February 1620000 1620000 Collected From March 1660000 1660000 3320000 Collected From April 900000 1800000 1800000 4500000 Collected From May 1000000 2000000 3000000 Collected From June 1050000 1050000 Total Collected 4180000 4460000 4850000 13490000 PAYMENTS March purchases 270000 270000 April purchases 1152000 288000 1440000 May purchases 1280000 320000 1600000 June purchases 1344000 1344000 Labor costs 900000 1000000 1050000 2950000 Variable Overhead 1260000 1400000 1470000 4130000 Fixed Overhead 310000 310000 310000 930000 Selling and administrative 290000 290000 290000 870000 Total Payments 4182000 4568000 4784000 13534000 Collections - Payments -2000 -108000 66000 -44000 Beginning Cash balance 25000 23000 5000 25000 Borrowing/repayment 0 90000 65100 24900 Interest 0 0 900 900 Ending Cash balance 23000 5000 5000 5000 BUDGETED INCOME STATEMENT Sales Revenues 4500000 5000000 5250000 14750000 Variable costs Materials 1440000 1600000 1680000 4720000 Labor 900000 1000000 1050000 2950000 Overhead 1260000 1400000 1470000 4130000 Total 3600000 4000000 4200000 11800000 Contribution Margin 900000 1000000 1050000 2950000 Fixed production Cost 380000 380000 380000 1140000 Fixed Selling and Admin 320000 320000 320000 960000 Interest Expense 0 900 249 1149 Net Income 200000 299100 349751 848851

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: James D. Stice, Earl K. Stice, Fred Skousen

16th Edition

324376375, 0324375743I, 978-0324376371, 9780324375749, 978-0324312140

Students also viewed these Accounting questions

Question

Discussion Thread: Computer Science Background / Experience

Answered: 1 week ago