Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am working on a project for a managerial accounting class. I am supposed to create a contribution quarterly projected income statement. However, I was

I am working on a project for a managerial accounting class. I am supposed to create a contribution quarterly projected income statement. However, I was provided with baseline check figures for the final answers and they don't match what I got from my computations. I have attached an image of the provided data and what I have so far.
My answer - $1,250,625- actual answer - $757,763
My answer - $39,262- actual answer - $5,898
My answer- $1,211,362-actual answer - $751,864
What am I doing wrong?
Additional data:
Unit Sales
April -7,650 Base Model -7,650
May -8,400 Base Model -8,400
June -9,200 Base Model -7,360 Premium Model -1,840
Weighted Sales Price - $260
July - $257.74 August - $256.91 September - $257.42 Oct. - $253.65
Weight Avg. Unit Cost - $169
July - $170.40 August - $172.50 Sept. - $175.30 Oct. - $176
Minimum ending cash balance - $40,000
Ending inventory percentange of next month's sales -75%
Percentage of purchases paid in: current mo -50%, following month -50%
Percentage of sales collected in: Current month -20%, following mo.-50%, second following mo,.-30%
New fixed asset purchases - Sept. $100,000
Quarterly dividends - $20,000
Line-of-credit annual interest -8%(line of credit open)
Variable expenses:
Sales commissions (% of sales)-5%
Shipping & handling (per unit)- $15.00
Fixed expenses: (per mo.)
Wages/salaries - $315,000
Rent - $26,000
Utilities - $9,500
Insurance expired - $4,500
Depreciation - $16,000
Other S&A - $38,000
Advertising - $0
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Principles Of Auditing And Other Assurance Services

Authors: Ray Whittington, Kurt Pany

17th Edition

0073379654, 9780073379654

More Books

Students also viewed these Accounting questions