Prepare a budgeted income statement for the quarter ended

Assignment Help Marketing Management
Reference no: EM13727517

Stillwater Video Company, Inc. produces and markets two popular video games, High Range and Star Boundary. The closing account balances on the company's balance sheet for the last year are as follows: Cash, $18,735; Accounts Receivable, $19,900; Materials Inventory, $18,510; Work in Process Inventory, $24,680; Finished Goods Inventory, $21,940; Prepaid Expenses, $3,420; Plant and Equipment, $262,800; Accumulated Depreciation-Plant and Equipment, $55,845; Other Assets, $9,480; Accounts Payable, $52,640; Mortgage Payable, $70,000; Common Stock, $90,000; and Retained Earnings, $110,980.

Operating budgets for the first quarter of the coming year show the following estimated costs: direct materials purchases, $58,100; direct materials usage, $62,400; direct labor expense, $42,880; overhead, $51,910; selling expenses, $35,820; general and administrative expenses, $60,240; cost of goods manufactured, $163,990; and cost of goods sold, $165,440. Estimated ending cash balances are as follows: January, $34,610; February, $60,190; and March, $54,802. The company will have no capital expenditures during the quarter.

Sales are projected to be $125,200 in January, $105,100 in February, and $112,600 in March. Accounts receivable are expected to double during the quarter, and accounts payable are expected to decrease by 20 percent. Mortgage payments for the quarter will total $6,000 of which $2,000 will be interest expense. Prepaid expenses are expected to go up by $20,000, and other assets are projected to increase by 50 percent over the budgeted period. Depreciation for plant and equipment (already included in the overhead budget) averages 5 percent of total plant and equipment for the year. Federal income taxes (34 percent of profits) are payable in April. The company pays no dividends.

Required

1. Prepare a budgeted income statement for the quarter ended March 31.

2. Prepare a budgeted balance sheet as of March 31.

Reference no: EM13727517

Questions Cloud

What is the role of the information and news media : What is the role of the information and news media in the shaping of political opinions
Businesses and marketing efforts into new markets : Advances in _____ have opened many new markets for small businesses, allowing them to more effectively expand their businesses and marketing efforts into new markets.
What kinds of cultural challenges do companies face : What kinds of cultural challenges do companies face when expanding into foreign nations? From watching the video, how does Disney embrace local cultures when introducing its parks overseas
Covered interest arbitrage : Assume that the interest rates for both the U.S. and German banks are 2%. You borrow $1M dollars from a U.S. bank for 6 months, convert it to Euros and invest it in a German bank for 6 months. The spot rate is 1.3664 USD per EUR.
Prepare a budgeted income statement for the quarter ended : Stillwater Video Company, Inc. produces and markets two popular video games, High Range and Star Boundary. Prepare a budgeted income statement for the quarter ended March 31
Fully amortizing mortgage loan : A fully amortizing mortgage loan is made for $100,000 at 5 percent interest for 25 years. Payments are to be made monthly.
Decide whether to build a small or a large facility : A firm that plans to expand its product line must decide whether to build a small or a large facility to produce the new products. If it builds a small facility and demand is low, the net present value after deducting for building costs will be $400,..
Identify current legislation impacting unions : Identify current legislation impacting unions and where you see them going in the future. Your opinion/experience with either or both of these environments. Discuss positive employee relations strategies and non-monetary rewards.
Calculate the companys peso transaction exposure : Suppose an agribusiness in Texas exports its crops. It expects an 18 million peso invoice for an export to Mexico to be paid in 90 days. The current spot and 90-day forward rates are $0.7502/Peso and $0.7422/Peso respectively.

Reviews

Write a Review

 

Marketing Management Questions & Answers

  The blueray ltd produces a range of products the firm uses

the blueray ltd produces a range of products. the firm uses full manufacturing cost plus pricing to determine the

  Explain and analyze supply chain of three ebusiness websites

Explain and Analyze supply chain of three eBusiness websites and make sure that you describe the Supply Chain for selling books the old fashioned way

  What applications of learning theory and goal-setting theory

What applications of learning theory and goal-setting theory do you see in AELN's customer ser-vice training program?

  You must choose between two sales recruits one has scored

you must choose between two sales recruits. one has scored very high in terms of the quality of his interview but not

  Explain e-business websites using carsdirect

Explain E-Business Websites using CarsDirect and explain how the supply chain was modified from brick and mortar by the website

  Explain what must a brick and mortar company do to transform

Explain What must a brick and mortar company do to transform its strategy when it decides to transform into an eBusiness

  How is advertising and sales promotion similar

In every job there is some sales and marketing that must go on. You must persuade your boss to accept a new entrepreneurial idea; How is advertising and sales promotion similar? Dissimilar

  An expertise in building customer relationships

The Meredith Corporation has developed an expertise in building customer relationships through segmentation, targeting, and positioning. However, the amazing part is that they have accomplished this by focusing on only the female half of the po..

  Business plan-sa biometric locks company for luggage bags

A brief about the product SA Biometric Lock's Company for Luggage Bags. Increasing the growth with 20% by the end of 2016

  Explain competitive forces model

Explain Competitive Forces Model and How evident is the bargaining power of suppliers and customers within the industry

  Explain academic approach to e-business

What makes an online business a successful e-business? There are many factors. Mention four factors and explain why they are important - support your answer with examples

  In the first advertising campaign for carlson hotels its

in the first advertising campaign for carlson hotels its commitment to service was extolled and a loyalty program that

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd