Assignment Details
You are the managerial accountant at Reliable Company. You have been assigned to support the marketing department and manage its master budget. The marketing department is responsible for the following:
Managing the firm’s marketing
Hiring subcontractors
Selling the consulting expertise to smaller outside firms
The department’s expenses are as follows:
Salaries and benefits of $48,000/month
Web site operations of $21,000/ month
Online advertising expenses of $15,000/month
Miscellaneous expenses of $3,500/month
The sales forecast for its consulting services are as follows:
April: $190,000
May: $200,000
June: $205,000
The department pays a sales commission of 5%, and this is paid in the following month. Subcontractor expenses are estimated at 45% of sales and are paid the month after they are billed. Consulting fees are collected 20% in the month of sale, 70% in the following month, and 10% in the second month following sale.
Refer to the attached schedules.
Develop a master budget for the marketing department.
This task includes the following:
Completing the attached schedules for a master budget for the marketing department
Supporting schedules for cash disbursements and collections
Analyze additional needs and resources based on those budgets. Make recommendations based on those budgets.
Respond to the following for this assignment:
Develop the marketing department’s master budget.
Prepare a schedule of expected cash collections.
Make recommendations based on those budgets.
Please use the Unit 4 Assignment Template to submit your assignment.
Please review the Unit 4 IP video for assistance in completing your assignment.
Using the schedule template provided, complete the marketing department’s master budget and schedule of expected cash collections. In a 4-page report, provide your recommendations to support the marketing master budget. Submit both documents to complete the assignment. Please use APA formatting requirements for the word document.
Submitting your assignment in APA format means, at a minimum, you will need the following:
Title page: Remember the running head. The title should be in all capitals.
Length: 5 pages minimum
Body: This begins on the page following the title page and must be double-spaced (be careful not to triple- or quadruple-space between paragraphs). The typeface should be 12-pt. Times Roman or 12-pt. Courier in regular black type. Do not use color, bold type, or italics, except as required for APA-level headings and references. The deliverable length of the body of your paper for this assignment is 5 pages. In-body academic citations to support your decisions and analysis are required. A variety of academic sources is encouraged.
Reference page: References that align with your in-body academic sources are listed on the final page of your paper. The references must be in APA format using appropriate spacing, hanging indent, italics, and uppercase and lowercase usage as appropriate for the type of resource used. Remember, the Reference page is not a bibliography but a further listing of the abbreviated in-body citations used in the paper. Every referenced item must have a corresponding in-body citation.
Category: Accounting
-
Developing a Master Budget for the Marketing Department at Reliable Company
-
“Analyzing Accounts Receivable Using Pivot Table – Lab 1 Data”
Purpose: Use pivot table to analyze accounts receivable. Book page p.263
Data: Lab 1 data. (Canvas)
Analysis:
1. Put receivables in six 30-day buckets.
2. Detail the receivables from 61-90 days bucket.
Required:
Follow book example p263-269 (Lab1) to use Excel pivot table and conduct analysis mentioned above.
Screenshot what you have in excel after completing every step below and submit a WORD file.
Step 0: Understand the data
Step 1: Calculate “DAYS PAST DUE”
Step 2: turn the spreadsheet into a table and go to pivot table page by clicking “summarize with pivot
table
Step 3: drag “days past due’ to Rows and “invoice amount into ∑Values”;
Step 4: Select groups to group receivables into six 30-day bucket
Step 5: Format the pivot table
Step 6: Pull out receivables in 61-90 day time period
To be submitted:
Please submit your assignment in WORD file. Put your screen shot in a WORD file, clearly label your
screenshot such as “Step1”. Put the homework title, your section, and your name in the Title of the file
and name the file the same way “HWTitle_01-JamesBond”. Use your name and section number as the
header in the Word file, such as “01_JamesBond”. Insert page numbers. Points will be deducted if not
following the instructions and you will receive a 0 if not submitted in a WORD file.
1. Screenshot after you finish each step listed above except for step 0.
– Include your name inside your screenshot for Step1, 5, and 6, meaning that you need to type
your name in the spreadsheet so that you can screenshot it. Points will be deducted if no name
is shown anywhere in the spreadsheet.
*when you screenshot a large dataset, just screen shot the first 10 or more rows.
* Note that in the video, I misspoke and said that it is okay to miss Step 3 and 4 screenshots,
which was not what I meant, and it is hard to change. So you need to have step 3 and 4 screenshot -
“Embracing Diversity: Overcoming Conflict in the Workplace”
I would like this essay to go along the lines of how conflict is unavoidable in any workplace, and how I’ve had a professional career for the past 2 years and I’ve dedicated myself in making sure that me and my coworkers feel included and everyone feels comfortable and excited to come to work everyday. One conflict I face while working overseas was not only the language barrier and culture shock from moving from New York City to west Africa but while working on a new construction project for the company I work for(Sankaran Group) one of my coworkers has a habit of wanting to always work alone and never wanting to interact with anyone while we are all working on the same project. I had the idea to go to lunch all together so we can get to know each other better and so that ill work will improve all together as a team she didn’t want to but after more persuading she finally came along and after we were all able to work and excel in every assignment that was given to us.
-
“Financial Analysis and Risk Assessment of XYZ Insurance Company” Summary: After reviewing the financial statements of XYZ Insurance Company, several risks were identified that could potentially impact the company’s financial health. These risks include: 1. Underwriting Risk: The company
Please review the attached financial statements and provide a written, summary narrative as to what risks you identified from these statements. In your summary, identify any negative or positive trends you see and include your overall conclusion of the financial health of this insurance company.
-
“Completing Form 1065: Understanding Partnership Tax Returns and the Importance of Accurate Reporting” Introduction Form 1065, also known as the U.S. Return of Partnership Income, is a tax return form used by partnerships to report
This assignment consist of having to compelete form1065 and a3 page paper with 2 credible sources. I have attached form1065 along with exact instructions on what information should be included within the 3 pages. PLEASE NO PLAGAIRISM.
-
Conformity of LIFO Assumption with Matching Principle Title: LIFO Assumption: Conformity with the Matching Principle The Last-In, First-Out (LIFO) assumption is a method of inventory valuation where the last items purchased or
Group 21: Why is the LIFO assumption considered to be in conformity with the matching principle? Please explain and provide example.
-
“Analyzing the Impact of Social Media on Consumer Behavior: A Case Study of Instagram” Introduction Social media has become an integral part of our daily lives, with platforms such as Instagram, Facebook, and Twitter dominating the online landscape. These
written assignment with references and in-text referencing. there are no word limit. may need to use excel
-
Jane’s Skateboards Milestone 1: T-Accounts and General Ledger Instructions
Instructions
Complete requirements 1 through 3 of Jane’s Skateboards for the first milestone of the course project. You have the option of using either the T-Accounts tab for posting Journal Entries or the General Ledger tab.
You will use the Excel Project Template for Jane’s Skateboards attached below.
DO NOT change the Excel template drop-down menus or formulas that are already in the template.
You should watch the videos in the Content tab above, under Week 2, to assist you in preparing this assignment.
Save your file as “LastnameFirstinitial-ACCT105-M1.”
Submit your work by midnight ET on Day 7 (Sunday).
**NOTE: Please make sure you review the instructions in the Excel template, so you do not miss any requirements. Again, DO NOT change the Excel template format, drop-down menus, or formulas that are already in the template.
Your homework exercises/problems will be evaluated according to the following Homework Problems Grading:
GradeHomework Problems Grading Criteria
90-100%
Assigned exercises/problems are completed in full.
Work demonstrates effective application of the concepts/principles covered in the chapter.
Work thoroughly explains answers and calculations.
Solutions are calculated with no errors or insignificant errors.
80-89%
Assigned exercises/problems are completed in full or are significantly complete.
Work demonstrates effective application of most concepts/principles covered in the chapter.
Work thoroughly explains most answers and calculations.
Solutions are calculated with insignificant errors.
70-79%
Assigned exercises/problems are mostly complete.
Work demonstrates effective application of some concepts/principles covered in the chapter.
Work explains some answers and calculations.
Solutions are calculated with significant errors.
60-69%
Assigned exercises/problems are fairly complete.
Work demonstrates effective application of a few concepts/principles covered in the chapter.
Work explains a few answers and calculations.
Solutions are calculated with significant errors.
0-59%
Assigned exercises/problems are less than 50% complete.
Work does not demonstrate effective application of the concepts covered in the chapter.
Work submitted does not thoroughly explain answers and calculations.
Solutions are not calculated or are calculated with significant errors. -
“Valuing Rio Tinto Company Ltd: Estimating Stock Price and Cost of Capital, and Analyzing the Impact of an Important Announcement”
You will value the company stock price and estimate cost of capital, and estimate the impact of an important announcement on its stock prices. In this assessment you will use rio
tinto company ltd as the basis for the assesment in part A
PART A company allocation : RIO TINTO COMPANY LTD -
“The Current State of Banking in Nigeria: A Comprehensive Literature Review”
Course: Accounting and Finance This paper is for dissertation just for literature review . Pls resdy the assignment brief to understand what do. This is the part 2 . I’ve attached the literature review part 2. This is a continuation of what I’ve ready done as I’ve been told it’s way too short . Assist me and continue on it . Read through part 2 literature review attached too Please let it be similar and let it flow together but with obviously more improvements and changes . The topic is current state of banking in Nigeria. Pls do research to help me complete this literature review part 2 to very high quality. Please read the assignment brief thoroughly to understand what do and how to complete this paper to a high level. All the information you may need will be attached, incase of any additional information pls do message me The assignment brief and mark scheme is attached here so pls make use of it and please especially follow the mark scheme as much as you can as that’s also attached . Please write in UK English not American English