Premium Essay

Managerial Cost Accounting Ch8-24

In:

Submitted By imsmilin
Words 521
Pages 3
1. Prepare the following, by quarter and in total, for year 2: | | | a. A schedule of expected cash collections on sales. | | | | b. A schedule of expected cash disbursements for merchandise purchases. | | | | | | | | Schedule of Expected Cash Collections | Year 2 In Quarter | | | Frist | Second | Third | Fouth | Total | Year 1: | | | | | | Fouth Quarter Sale | =300000*65% | | | | =B13 | Year 2: | | | | | | First Quarter Sale | =400000*0.33 | =400000*0.65 | | | = B15+C15 | Second Quarter Sale | | =500000*0.33 | =500000*0.65 | | =C16+D16 | Third Quarter Sale | | | =600000*0.33 | =600000*0.65 | =D17+E17 | Fouth Quarter Sale | | | | =480000*0.33 | =E18 | Total Cash Collections | =B13+B15 | =C15+C16 | =D16+D17 | =E17+E18 | =F13+F15+F16+F17+F18 | | | | | | | Schedule of Expected Cash Disbursements for Merchandise Purchases | Year 2 In Quarter | | | Frist | Second | Third | Fouth | Total | Year 1: | | | | | | Fouth Merchandise Purchase | =180000*0.8 | | | | =B25 | Year 2: | | | | | | First Merchandise Purchase | =260000*0.2 | =260000*0.8 | | | = B27+C27 | Second Merchandise Purchase | =310000*0.2 | =310000*0.8 | | =C28+D28 | Third Merchandise Purchase | | =370000*0.2 | =370000*0.8 | =D29+E29 | Fouth Merchandise Purchase | | | =240000*0.2 | =E30 | Total Cash Disbursements | =B25+B27 | =C27+C28 | =D28+D29 | =E29+E30 | =F25+F27+F28+F29+F30 | | | | | | | 2. Compute the expected cash disbursements for selling and administrative expenses, by quarter and in total, for year 2 | | | | | | | Schedule of Expected Cash Disbursement For Selling and Administrative Expenses | Year 2 by Quarter | | Frist | Second | Third | Fouth | Total | Budget Sale | =400000 | =500000 | =600000 | =480000 | =SUM(B38:E38) | Fixed Expense | =90000 |

Similar Documents

Premium Essay

The First Time Management

...Atlanta • Brussels • Chicago • Mexico City • San Francisco Shanghai • Tokyo • Toronto • Washington, D. C. ................. 11066$ $$FM 11-23-04 15:23:09 PS PAGE iii Special discounts on bulk quantities of AMACOM books are available to corporations, professional associations, and other organizations. For details, contact Special Sales Department, AMACOM, a division of American Management Association, 1601 Broadway, New York, NY 10019. Tel.: 212-903-8316. Fax: 212-903-8083. Web Site: www.amacombooks.org This publication is designed to provide accurate and authoritative information in regard to the subject matter covered. It is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional service. If legal advice or other expert assistance is required, the services of a competent professional person should be sought. Library of Congress Cataloging-in-Publication Data Belker, Loren B. The first-time manager / Loren B. Belker, Gary S. Topchik.—5th ed. p. cm. ISBN 0-8144-0821-4 1. Supervision of employees. 2. Office management. I. Topchik, Gary S. II. Title. HF5549 .12 .B453 2005 658.3 02—dc22 2004019486 2005, 1997, 1993, 1986, and 1981 AMACOM, a division of American Management Association, New York. All rights reserved. Printed in the United States of America. This publication may not be reproduced, stored in a retrieval system, or transmitted in whole or in part, in any form or...

Words: 65840 - Pages: 264

Premium Essay

Learning-Guide

...not be reproduced in any manner whatsoever except for the purposes of individual study. University Provider Number 00025B © The University of Queensland contents Contents Module 1 Introduction to electronic commerce Objectives Basic elements of electronic commerce (EC) 1 1 3 Differences between electronic commerce and traditional commerce 5 New ways of doing business with electronic commerce History of electronic commerce (EC) Planning an e-commerce project Legal, ethical and international issues Case study guidelines 6 8 10 10 11 Module 2 Business decision-making and planning for electronic commerce 17 Objectives Planning an e-commerce project Economic models Competitive advantage and electronic marketplaces Transaction cost economics 17 18 29 30 34 Module 3 Technologies for electronic commerce Objectives The Internet and electronic commerce The general structure of the Internet Internet protocols 37 37 38 39 40 Internet services Intranets and extranets Internet connection options The World Wide Web 43 45 48 48 Module 4 Creating a commercial Website Objectives Introduction...

Words: 38720 - Pages: 155