Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Card Cavern is a retail store selling video games. Sales are uniform for most of the year but pick up in June and December both

Card Cavern is a retail store selling video games. Sales are uniform for most of the year but pick up in June and December both games in anticipation of summer and winter holidays. Card Cavern also sells and repairs game systems. The forecast of sales and service revenue for the March-June 2014 is as follows.

March Expected Sales Revenue= $9000 Expected Service Revenue=$1200 Total Revenue=$10,200

April Expected Sales Revenue= $10000 Expected Service Revenue= $1500 Total Revenue= $11500

May Expected Sales Revenue= $10800 Expected Service Revenue= $2100 Total Revenue= $ 12900

June Expected Sales Revenue= $ 18800 Expected Service Revenue= $ 4500 Total Revenue= $23300

Almost all the service revenue is paid for by bank credit card so Card Cavern budgets this as 100% bank card revenue. The bank charge and average fee of 3% of the total. Half of the sales revenue is also paid for by bank credit card, for which the fee is also 3% on average. About 30% of the sales are paid in cash, and the rest (remaining 20%) are carried on a store account. Although the store tries to give store credit to only the best customers, if still averages about 2% of uncollectible accounts: 70% of store accounts are paid in the month following the purchase and 28% are paid 2 month after the purchase.

Solve for the following

March sales revenue collected in May?

March sales revenue collected in April?

April sales revenue collected in May?

April sales revenue collected in June?

May sales revenue collected in May?

May sales revenue collected in June?

June sales revenue collected in June?

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

Trucking Industry IRS Audit Techniques Guide

Authors: Internal Revenue Service

1st Edition

1304135640, 978-1304135643

More Books

Students also viewed these Accounting questions